Mapping with Sorter Transformation

Mapping with Sorter Transformation # To sort data in ascending or descending order. # Can sort data from relational or flat file sources. # The Sorter transformation contains only input/output ports. # All data passing through the Sorter transformation is sorted according to a sort key. # The sort key is one or more ports […]

Read More

Informatica Sorter Transformation Overview

Sorter Transformation Overview # To sort data in ascending or descending order. # Can sort data from relational or flat file sources. # The Sorter transformation contains only input/output ports. # All data passing through the Sorter transformation is sorted according to a sort key. # The sort key is one or more ports that […]

Read More

Informatica Filter Transformation

Filter transformation – Part 1 Use the Filter transformation to filter out rows in a mapping. As an active transformation, the Filter transformation may change the number of rows passed through it. The Filter transformation allows rows that meet the specified filter condition to pass through. It drops rows that do not meet the condition. […]

Read More

Informatica Transformations – Types

Types of Transformations  A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. For example, an Aggregator transformation performs calculations on groups of data. Transformations in a mapping represent the operations the Integration Service performs on the data.  Transformations can be of the […]

Read More

Informatica Transformations – Overview

Transformation Overview A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. Transformations in a mapping represent the operations the Integration Service performs on the data. Transformations can be active or passive. Transformations can be connected to the data flow, or they […]

Read More