[How To] Informatica - Load the first 3 rows from a flat file into a Target

There are often scenarios where we wish to load only selected few rows from source to the target. In the scenario that I explain below, I demonstrate how we can load only the first 3 rows from source to target.

This can be achieved by generating unique Record_Number's for each row and then filtering the records where Record_Number>=3. We can then pass the output of the filter directly to target.


::Generation of Unique Record_Numbers::

::Filtering First 3 Records::

The implementation of generation of unique Record_Number can either be done by sequence generator or using an Expression transformation. We use Expression transformation in our example just to learn something new!