Tag: Transformations-Lab

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 »

How to remove duplicate records using Expression

No Picture

How to remove duplicate records using Expression In the last post we have used Aggregator Transformation to remove the duplicate records. In this post we will use the Expression transformation to remove theĀ duplicate JOB_ID from the source Flat…

Read More »

How to remove duplicate records Using Aggregator

No Picture

How to remove duplicate records Using Aggregator There are couple of options available in informatica to remove duplicate records from the source.  For Relational Tables 1. Source Qualifier > ‘SELECT DISTINCT’ option 2. Source Qualifier > SQL override…

Read More »

How to Load only Half of the records from Source table

No Picture

Load only Half of the records from Source table The requirement is to process only half of the records from the source table. To do this we need to calculateĀ the total number of rows (TOTAL-COUNT) in the source…

Read More »