Tag: Filter Transformation

How to load every 5th record into target table

No Picture

How to load every 5th record into target table We need to read the source table and load only 1st and every 5th (nth) records to target. Let’s start the mapping for this. We need a sequence generator and…

Read More »

Informatica Filter Transformation

No Picture

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…

Read More »