Hi All,
Please let me know how through Datastage job (parallel) we can remove the header and trailor in sequential file. If the header and trailor has same no of field as the records and also the delimiter is same as the record.
Is it done through HEAD /TAIL stage....
Please resolve my query.
Thanks,
Ankita
removal of header and trailor from seq file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 4
- Joined: Mon Jul 23, 2007 3:47 am
-
- Participant
- Posts: 25
- Joined: Fri Jan 11, 2008 12:49 am
- Location: Pune, India
-
- Participant
- Posts: 33
- Joined: Mon Nov 12, 2007 1:02 am
- Location: Bangalore
Re: removal of header and trailor from seq file
If the header has a identifiable format, [like it starts with 'HDR' or a particular col like 'Record type' is 1], then you may employ either filter stage or transformer to apply a constraint to knock down header and trailers. I have done this once with fixed length file, but I am a nooB with DS Px myself. Hope this helps.ankitaporwal wrote:Hi All,
Please let me know how through Datastage job (parallel) we can remove the header and trailor in sequential file. If the header and trailor has same no of field as the records and also the delimiter is same as the record.
Is it done through HEAD /TAIL stage....
Please resolve my query.
Thanks,
Ankita
Rishabh Sagar V
Bangalore
Bangalore