WorksheetsInformatica Questions
Total questions: 10
Worksheet time: 3mins
ETL stands for?
Extract-Transform-Load
Extract-Translate-Load
Extract-Load-Transform
Extract-Target-Load
Which is NOT a PowerCenter Client Application?
Designer
Workflow Manager
Workflow Monitor
Worksheet
What is the meaning of Transformation?
Process of retrieving data from one or more sources
Process of inserting that formatted data into the target database, data store, data warehouse, or data lake
Involves taking that data, cleaning it, and putting it into a common format, so it can be stored in a targeted database, data store, data warehouse, or data lake
All of the above.
Client Application use to create ETL mappings.
Repository Manager
Workflow Manager
Designer
Wofklow Monitor
Needed to create simple ETL mapping.
Source
Target
Transformation
All of the Above
What is a Joiner Transformation?
Joins data from different databases or flat file systems.
Joins data into multiple transformations based on group conditions.
Joins data into multiple transformations based on group conditions.
None of the Above.
What is a Router Transformation?
Filter data based on criteria
Routes data into multiple transformations based on group conditions.
Joins data from different databases or flat file systems
None of the Above
What is a Union Transformation?
Joins data from different databases or flat file systems.
Merges data from different databases or flat file systems.
Executes SQL queries against a database.
Reads XML from one input port and outputs data to one or more output ports
Client Application to perform configurations.
Designer
Workflow Manager
Workflow Monitor
Worksheet
Client Application to monitor workflow execution.
Designer
Workflow Manager
Workflow Monitor
Worksheet
