Free IPC Mapping Design & Transformation Techniques Questions and Answers — Questions and Answers
Question 1: What is a mapping in Informatica PowerCenter?
- A set of workflow tasks.
- A design of data flow and transformations (Correct answer)
- A session log.
- An execution schedule.
Correct answer: A design of data flow and transformations
In Informatica PowerCenter, a mapping is the fundamental object that defines the flow of data from source to target. It graphically represents the data transformation logic, illustrating how data is extracted, manipulated, and loaded using various transformations. Mappings serve as the core blueprints for data integration processes, specifying the exact steps for data movement and modification.
Question 2: Which transformation is used to filter rows in a mapping?
- Router transformation.
- Filter transformation (Correct answer)
- Aggregator transformation.
- Expression transformation.
Correct answer: Filter transformation
The Filter transformation in Informatica PowerCenter is specifically designed to filter rows of data based on a user-defined condition. Only those rows that satisfy the specified condition are passed through to the next transformation or target. This allows for selective processing of data, ensuring that only relevant records continue in the data flow.
Question 3: What is the purpose of an Expression transformation?
- To route data based on conditions.
- To perform calculations or data manipulation (Correct answer)
- To join data from multiple sources.
- To remove duplicate rows.
Correct answer: To perform calculations or data manipulation
The Expression transformation in Informatica PowerCenter is a versatile tool used to perform calculations, concatenate strings, convert data types, or apply any other row-level data manipulation. It allows users to define expressions using various functions and operators to derive new values, modify existing ones, or implement complex business logic within the data flow.
Question 4: Which transformation allows branching based on multiple conditions?
- Joiner transformation.
- Router transformation (Correct answer)
- Filter transformation.
- Sorter transformation.
Correct answer: Router transformation
The Router transformation in Informatica PowerCenter is used to branch data rows into multiple output groups based on different, user-defined conditions. Unlike a simple Filter, which only passes or drops rows, the Router can direct rows to various distinct pipelines simultaneously. This enables complex conditional data flow and processing based on multiple criteria.
Question 5: What transformation is used to combine data from two sources?
- Aggregator transformation.
- Joiner transformation (Correct answer)
- Lookup transformation.
- Sorter transformation.
Correct answer: Joiner transformation
The Joiner transformation in Informatica PowerCenter is used to combine data from two heterogeneous sources or pipelines into a single stream. It performs a join operation, similar to a SQL JOIN, based on a specified join condition between the input data sets. This allows for integrating related data from different origins into a unified data flow.
Question 6: How does an Aggregator transformation function?
- Filters rows based on condition.
- Performs aggregate functions on grouped data (Correct answer)
- Splits data into multiple streams.
- Joins two data sets.
Correct answer: Performs aggregate functions on grouped data
The Aggregator transformation in Informatica PowerCenter is used to perform aggregate calculations, such as SUM, AVG, COUNT, MIN, and MAX, on groups of data. You can define group-by ports to specify how data should be grouped before the aggregate function is applied. This transformation is essential for summarizing and consolidating data based on specific criteria.
Question 7: Which transformation is used to find and replace values in a data stream?
- Normalizer transformation (Correct answer)
- Router transformation.
- Filter transformation.
- Joiner transformation.
Correct answer: Normalizer transformation
The Normalizer transformation is primarily used to convert denormalized data, often with repeating groups, into a normalized format. It effectively 'finds' data spread across multiple columns in a single row and 'replaces' that structure by creating multiple rows, each containing a single instance of the repeating data. This process transforms the data stream into a more structured and normalized representation.
Question 8: What is the use of a Lookup transformation?
- To join two pipelines.
- To fetch data from a relational table or file (Correct answer)
- To filter rows.
- To aggregate data.
Correct answer: To fetch data from a relational table or file
The Lookup transformation is used to retrieve data from a relational table, flat file, or another source based on a specified condition. It allows a mapping to fetch additional columns of data from a lookup source and integrate them into the data stream. This is crucial for data enrichment, validation, and populating missing information without performing a full join.
Question 9: Which transformation is used to sort data before loading into target?
- Sorter transformation (Correct answer)
- Aggregator transformation.
- Expression transformation.
- Router transformation.
Correct answer: Sorter transformation
The Sorter transformation is specifically designed to sort data within a data flow based on one or more specified port values. It arranges records in either ascending or descending order, which can be crucial for preparing data for subsequent transformations like Aggregator or Joiner, or for ensuring the target data is ordered as required. This improves data readability and can optimize downstream processing.
Free IPC Mapping Design & Transformation Techniques Questions and Answers
What is a mapping in Informatica PowerCenter?