Check the Header of Flat file while Mload

General
Enthusiast

Check the Header of Flat file while Mload

Every day i will receive a Flat file which i have Mload it in prod. So i have to check the Header in file and make sure it matches with old one.

File Delimited '|'

Eg : S_NO | LNAME | FNAME  (Given header)

Eg : S_NO | LNAME | FNAME (File header)

Some times source changes the header so i need pre check before i load.

Plz help me out

Thanks

Balaji

Tags (3)
1 REPLY
Enthusiast

Re: Check the Header of Flat file while Mload

Why you want to do this pre-check via MULTILOAD? You can check this via UNIX and discard the file if header is not matching. In that case, you don't have to invoke Multiload utility.