Avoid header and trailer using Multiload

Tools

Avoid header and trailer using Multiload

Hi ,
I have a file with header, data racords and trailer. Data record is delimited with comma and header and trailer are fixed width.The header and trailer starts with (HDR,TRA).
I need to avoid the header and trailer while loading the file with Multiload. Please help me in this case.

Thank you,

Regards,
Kiran
5 REPLIES
N/A

Re: Avoid header and trailer using Multiload

Hi Kiran,

While defining the layout of records put a field REC_ID_IN( Record Id indicator). this will store the record indicator for each row.
you can filter the Header and trailer records in the application phs

APPLY label WHERE REC_TD_IN NOT IN('HDR','TRA');

hope it helps...

Re: Avoid header and trailer using Multiload

Thank you, I will try it. Thank you once again.

Re: Avoid header and trailer using Multiload



Hi Kiran

Can i request you to show the sample two records in the file .I am new to teradata so i want to see the file records.

Thanks inadvance

Regards
Bharati

Re: Avoid header and trailer using Multiload

Hi Barathi,

Below find the sample record.

HDR2008120313325900000000000Inter-mediatE 6.01
23044953,,RUFHBSB,404911DDFC0370113,,9198YURB20440,,,5303013,,20080903102356,1,,,,,,,,,,,,919YTRHF099002,,91980GEVBDB40
TRA2008120313325900000000000Inter-mediatE 6.01
Teradata Employee

Re: Avoid header and trailer using Multiload

All records in one input file must be able to use the same LAYOUT.
You could write INMOD or AXSMOD user exit to omit the header & trailer.