Informatica Interview Questions and Answers

  • Latest Informatica FAQ”S

    Question.1 What will happen if you are using Update Strategy Transformation and your session is configured for “insert”? Answer: If U using a update strategy in any of UR mapping ,then in session properties U have to set treat source rows as Data Driven ,if U select insert or update..

  • Important Informatica Questions & Answers

    Question.1 What is change data capture? Answer: Change Data Capture (CDC) helps identify the data in the source system that has changed since the last extraction. With CDC, data extraction takes place at the same time the insert, update , or delete operations occur in the source tables, and the..

  • Latest Informatica Question & Answer

    Question.1 The architectural difference between INFORMATICA 6.1 and 7.1 Answer: Few differences or the enhancements in 7.1, which I have noticed are VERSIONING in 7.1, Recovery, Can looking flat files. Question.2 Can U tell how normalize works with an example? Answer: Normalization is used to transform non tabular data structure..

  • 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..

  • Informatica Interview Questions and answers for experienced

    Question.1  What is the difference between connected and unconnected transformation? Answer:   Connected Transformation: Connected transformation is connected to other transformations or directly to target table in the mapping. Unconnected Transformation: An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns..

  • 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..