I got a requirment where i am getting a flat file and i need to add header and trailer to that file which later ftped to another server.
I designed a job like this.
Code: Select all
Header -------------------->
Sequential file ----------->
Trailer----------------------> Funnel(Sequence) -------->Target File
Here i am facing a issue.When i am running this funnel in parallel header is not coming on top rather in between the data but trailer is always in the bottom.
When i tested with running funnel in sequence mode,it giving me desired output like
Header
Data
Trailer
My file is 2GB so i dont think its good practice to run funnel in sequence mode.Can anyone help me to resolve it or is there any other way to do this.