How to load data based on even and odd record numbers in Informatica

We have a requirement to split the records into the multiple target or target files. The even and odd records are split into two targets. This scenario we uses Router Transformation to achieve.

Here we have the suppliers table with few records

Creating the two target tables.

To split the records by using the position in the source file as even and odd using Expression and Router Transformation.

In the router transformation, we have to group the records by expression and map to the target and save.

MOD (SupplierID, 2)=1 As Odd

MOD (SupplierID, 2)=0 As Even

No Comments

Leave a Comment

Your email address will not be published.