Hello,
I have a text input file which contains header, footer and detail records that needs to be transferred into different table outputs. Like If the header record found then insert into table1 and detail record found then insert into table2. In my case first line of the file is always header and last line of the file is always footer. I need to do below steps

1. Read the header record and insert into table1. Also i need to generate the UUID for the file and insert with the record.
2. Read the detail records and insert into table2. For each record i need to pass a UUID with that.
3. Ignore the footer record.

Is it possible with PDI? If so please provide me a sample for that.

Note: I have UUID as function in the DB which can be called as table input and join with the text file input.

Thanks
Murali