informatica interview questions and answers Interview Questions and Answers

  • Informatica ETL Interview Questions and Answers

    Question.1 Can you use mapping without source qualifier? Answer:  Not possible, If source RDEMS/DBMS/Flat file use SQ or use normalizer if the source cobol feed.  Question 2.When do you use a normalizer? Answer:  Normalized can be used in Relational to denormilize data. [sociallocker] Question.3 What are stored procedure transformations. Purpose..



  • Informatica Interview Questions with answers

    Question.1 What are the different uses of a repository manager? Answer: Repository manager used to create repository which contains metadata the informatica uses to transform data to from source to target. And also it use to create informatica user’s and folders and copy, backup and restore tie repository . Question.2..



  • Informatica Interview questions with answers

    Question.1  What are the components of Informatica? And what is the purpose of each? Answer:   Informatica Designer, Server Manager & Repository Manager. Designer for Creating Source & Target definitions, Creating Mapplets and Mappings etc. Server Manager for creating sessions & batches, Scheduling the sessions & batches, Monitoring the trig jered..



  • ETL Testing Interview Questions and answers

    Question.1   What is a Data Warehouse? Answer:    A Data Warehouse is a collection of data marts representing historical data from different operational data source (OLTP). The data from these OLTP are structured and optimized for querying and data analysis in a Data Warehouse. Question.2   What is a Data mart? Answer:  ..



  • Informatica Interview Questions and Answers

    Question.1 What is Data warehouse? Answer: According to Bill Inmon, known as father of Data warehousing. “A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management’s decision making process”. Question.2 What are the types of data warehouses? Answer: There are three..



Quick Enquiry
We respond as soon as possible.
2016 (C) All rights reserved.
Submit your details
2017 (C) All rights reserved.
GRAB THIS OFFER