Informatica Interview Questions and Answers
Ques 1. What is Informatica PowerCenter?
Informatica PowerCenter is an ETL (Extract, Transform, Load) tool used for data integration and warehousing.
Ques 2. Explain the difference between ETL and ELT.
ETL (Extract, Transform, Load) is a process where data is extracted from source systems, transformed, and then loaded into a data warehouse. ELT (Extract, Load, Transform) is a process where data is first extracted and loaded into the target system, and then transformations are applied.
Ques 3. What is a Session in Informatica?
A session in Informatica is a task that represents the execution of a workflow. It is the smallest unit of work in a workflow.
Ques 4. Explain the difference between a Mapping and a Mapplet.
A mapping is a set of source and target definitions linked by transformations, while a mapplet is a reusable object that contains a set of transformations.
Ques 5. What is a Repository in Informatica?
A repository in Informatica is a relational database that stores metadata and configuration information about the various objects managed by Informatica.
Most helpful rated by users: