1. What is Informatica primarily used for?
A. Operating system management
B. Data integration and ETL processes
C. Web application development
D. Database design
Answer: B
2. What does ETL stand for in Informatica?
A. Extract, Transform, Load
B. Evaluate, Test, Launch
C. Encode, Transfer, Link
D. Extract, Transfer, Link
Answer: A
3. Which Informatica component is used to create mappings between source and target?
A. Workflow Manager
B. Repository Manager
C. Mapping Designer
D. Workflow Monitor
Answer: C
4. What is a transformation in Informatica?
A. A data storage location
B. A process that modifies or filters data
C. A source connection
D. A database index
Answer: B
5. Which transformation is used to filter rows in Informatica?
A. Filter Transformation
B. Router Transformation
C. Expression Transformation
D. Sorter Transformation
Answer: A
6. What is the purpose of a Lookup transformation?
A. To sort data
B. To validate data
C. To retrieve related data from a table or cache
D. To delete unwanted data
Answer: C
7. What is the function of Workflow Manager in Informatica?
A. To monitor data loading
B. To design ETL mappings
C. To create and manage sessions, workflows, and tasks
D. To generate reports
Answer: C
8. What does the Repository Manager do?
A. It runs SQL queries
B. It manages objects in the Informatica repository
C. It loads data into the target
D. It stores only session logs
Answer: B
9. Which transformation is used to perform calculations on data?
A. Router Transformation
B. Expression Transformation
C. Aggregator Transformation
D. Lookup Transformation
Answer: B
10. What is the use of the Aggregator transformation?
A. To join multiple sources
B. To calculate aggregate functions like SUM or AVG
C. To sort records alphabetically
D. To perform data validation
Answer: B
11. Which transformation divides data based on conditions?
A. Rank Transformation
B. Router Transformation
C. Filter Transformation
D. Sequence Generator
Answer: B
12. What is a Source Qualifier transformation?
A. It filters target data
B. It defines how Informatica reads data from a source
C. It performs data validation
D. It generates surrogate keys
Answer: B
13. What is the purpose of a Joiner transformation?
A. To merge multiple files
B. To combine data from two sources based on a condition
C. To rank rows
D. To split data
Answer: B
14. Which transformation helps remove duplicate rows?
A. Router Transformation
B. Sorter Transformation
C. Rank Transformation
D. Filter Transformation
Answer: B
15. What is the default cache type used in Lookup transformation?
A. Static Cache
B. Dynamic Cache
C. Persistent Cache
D. Reusable Cache
Answer: A
16. What is a session in Informatica?
A. A connection between mappings and workflows
B. A database connection file
C. A debugging tool
D. A log viewer
Answer: A
17. Which file stores all Informatica metadata?
A. Source file
B. Target file
C. Repository database
D. XML file
Answer: C
18. Which transformation is used to generate unique values?
A. Expression Transformation
B. Sequence Generator Transformation
C. Rank Transformation
D. Filter Transformation
Answer: B
19. What is a reusable transformation in Informatica?
A. A transformation used only once
B. A transformation that can be shared across multiple mappings
C. A transformation with no input ports
D. A transformation used for reports
Answer: B
20. Which client tool allows you to monitor workflows in real time?
A. Workflow Designer
B. Repository Manager
C. Workflow Monitor
D. Mapping Designer
