[How To] Load records to different files

Scenario: Design a mapping to load the first 3 from a flat file into one File1, the next 4 records to File2 and remaining records to File3.

We first allot Records_No's to records either using a sequence generator or an Expression transformation as shown below. We then route the records based on Record_No to respective files using a Router transformation.


 ::Genereation of Record_No using Expression::

::Routing the records to diffrent files::