File validation

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Venki-ds
Premium Member
Premium Member
Posts: 6
Joined: Wed Nov 16, 2011 10:45 pm
Location: Chennai

File validation

Post by Venki-ds »

Hi there ,


Please let me know the approach of header and trailer validation of unix file through sequence jobs .

we will be receiveing the file with header and trailer ,in the trailer it has a row count of the file .need to trigger the job if row count of the file matches with trailer count

Kiindly provide some logical approches .

Thanks in advance.
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: File validation

Post by SURA »

Just the trailer?

Code: Select all

execute cmd activity (to get total rows) -->execute cmd activity (to get trailer count from file)-->UserVariable (compare)-->
There are different ways to do it. You can do it as a routine, script level , Using DS Job etc.
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Post Reply