Mappings & Transformations Flashcards

In Informatica Cloud Data Integration, what is the primary purpose of a mapping?

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.

Which transformation in Informatica Cloud is specifically used to pass only rows that meet a specified condition?

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.

What is the primary function of a Joiner transformation in Informatica Cloud?

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.

Which Informatica Cloud transformation can generate multiple output rows from a single input row containing repeating data?

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.

What does the Expression transformation in Informatica Cloud primarily allow you to do?

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.

In Informatica Cloud, what is the purpose of a Lookup transformation?

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.

How can the Sorter transformation in Informatica Cloud be used to remove duplicate rows from a data flow?

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.