Tag: Sorter Transformations

How to remove duplicate records using Sorter Transformation

No Picture

How to remove duplicate records using Sorter Transformation In the last two post we have seen how to remove duplicate records (Only one column) using Aggregator and Expression. We have identified the duplicate JOB_ID and skipped those rows…

Read More »

Mapping with Sorter Transformation

No Picture

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…

Read More »

Aggregator Transformation Overview

No Picture

Aggregator Transformation Overview¬† The Aggregator transformation performs aggregate calculations, such as average, Sum, Max & Min etc. The Aggregator is an active transformation that changes the number of rows in the pipeline. The Integration Service performs the aggregate…

Read More »

Informatica Sorter Transformation Overview

No Picture

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…

Read More »