Page 1 of 1

Audit file should match Source file

Posted: Sun Aug 19, 2007 9:22 pm
by chandra
Hi Frnds @
i hv one problem and looking for logic.
i get source file which contains actual data and another file is Aduit file. where i get summary of source file. like how many number of records and amount.
ex:- record count, amout->200,2500000.00
---------------------------
Source file should match -adut file.
other wise job should abort, this job i will use in seq.
I need ur best suggestion.whether i should write unix prog / it could be done in Datastage.
I tried with Compare stage but getting strange error that i hv posted earlier.No replay i got asusual.

Thanks :twisted:

Re: Audit file should match Source file

Posted: Sun Aug 19, 2007 9:38 pm
by chulett
Be more specific - when do you want to do this validation? Before even attempting to load the source file to ensure you have a complete file or after you've loaded it to ensure all was loaded correctly?
chandra wrote:I tried with Compare stage but getting strange error that i hv posted earlier.No replay i got asusual.
It would have helped if you had posted your question in the correct forum. :twisted:

Posted: Sun Aug 19, 2007 10:13 pm
by chandra
its a kick of job, not related to loading ..

job :-

match-->kick rest of job
else
Abort send a mail to team

Posted: Sun Aug 19, 2007 10:34 pm
by ag_ram
Can After job subroutines be used to accomplish the same