ICC Mappings & Transformations 1 — Questions and Answers
Question 1: In Informatica Cloud Data Integration, what is the primary purpose of a mapping?
- To define the flow of data from sources to targets, including all transformations applied along the way (Correct answer)
- To schedule data integration tasks at specific times
- To define connection properties for source and target systems
- To monitor the performance of data integration jobs
Correct answer: To define the flow of data from sources to targets, including all transformations applied along the way
A mapping defines the data flow logic from source to target, including all transformation rules applied to the data during processing.
Question 2: Which transformation in Informatica Cloud is specifically used to pass only rows that meet a specified condition?
- Router
- Filter (Correct answer)
- Expression
- Sorter
Correct answer: Filter
The Filter transformation evaluates each row against a condition and passes only the rows that satisfy the filter condition to the downstream pipeline.
Question 3: What is the primary function of a Joiner transformation in Informatica Cloud?
- To split data into multiple output pipelines
- To aggregate data based on grouping criteria
- To join data from two heterogeneous sources based on a join condition (Correct answer)
- To generate unique sequence numbers for records
Correct answer: To join data from two heterogeneous sources based on a join condition
The Joiner transformation combines data from two different pipelines or heterogeneous sources, enabling you to merge related data based on a specified join condition.
Question 4: Which Informatica Cloud transformation can generate multiple output rows from a single input row containing repeating data?
- Normalizer (Correct answer)
- Aggregator
- Router
- Rank
Correct answer: Normalizer
The Normalizer transformation converts denormalized data with repeating column groups into multiple normalized rows, expanding a single input row into multiple output rows.
Question 5: What does the Expression transformation in Informatica Cloud primarily allow you to do?
- Filter records based on conditions without passing rows forward
- Calculate values and perform row-level transformations without changing the number of rows (Correct answer)
- Join two data streams together using a key field
- Route data to different targets based on conditional logic
Correct answer: Calculate values and perform row-level transformations without changing the number of rows
The Expression transformation computes values and transforms data at the row level using built-in functions and expressions, without filtering, duplicating, or aggregating rows.
Question 6: In Informatica Cloud, what is the purpose of a Lookup transformation?
- To search a lookup source and return matching values based on a specified lookup condition (Correct answer)
- To rank records based on a specified column value
- To split incoming data into multiple conditional output groups
- To sort data in ascending or descending order before target load
Correct answer: To search a lookup source and return matching values based on a specified lookup condition
The Lookup transformation queries a lookup source such as a flat file or database table and returns values from that source based on the specified lookup condition.
Question 7: How can the Sorter transformation in Informatica Cloud be used to remove duplicate rows from a data flow?
- By enabling the Remove Duplicates option in the transformation properties
- By configuring the Distinct sort key in the output port settings
- By enabling the Distinct property on the Sorter transformation (Correct answer)
- By setting the Deduplication flag in the advanced transformation settings
Correct answer: By enabling the Distinct property on the Sorter transformation
The Sorter transformation with the Distinct property enabled removes duplicate rows by sorting the data and then eliminating records with identical values across all ports.
ICC Mappings & Transformations 1
In Informatica Cloud Data Integration, what is the primary purpose of a mapping?