What is a mapping in Informatica PowerCenter?
Correct!
Wrong!
A mapping defines the flow of data from sources to targets through transformations.
Which transformation is used to filter rows in a mapping?
Correct!
Wrong!
The Filter transformation allows rows to be passed based on a condition.
What is the purpose of an Expression transformation?
Correct!
Wrong!
Expression transformations are used to calculate or modify data values.
Which transformation allows branching based on multiple conditions?
Correct!
Wrong!
Router transformation directs rows into different groups based on conditions.
What transformation is used to combine data from two sources?
Correct!
Wrong!
Joiner transformation combines data based on matching keys.
How does an Aggregator transformation function?
Correct!
Wrong!
Aggregator performs aggregate calculations like sum, average, count on groups of rows.
Loading Questions...
Which transformation is used to find and replace values in a data stream?
Correct!
Wrong!
Normalizer transformation converts columns into rows and can be used to find/replace values.
What is the use of a Lookup transformation?
Correct!
Wrong!
Lookup is used to fetch related data from a reference table during the transformation process.
Which transformation is used to sort data before loading into target?
Correct!
Wrong!
Sorter transformation arranges data rows in ascending or descending order.