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… Continue reading How to remove duplicate records using Sorter Transformation
Tag: Transformations-Lab
How to remove duplicate records using Expression
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… Continue reading How to remove duplicate records using Expression
How to remove duplicate records Using Aggregator
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… Continue reading How to remove duplicate records Using Aggregator
How to Load only Half of the records from Source table
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… Continue reading How to Load only Half of the records from Source table