DSXchange

HI,

i should create control job to get the record count of the of the target file,my source is flat files ,how should i create this.what are the fields i should configure.how to use it in job sequencer to load 5 flat files.

Thanks
sunitha

However you like. Simplest is probably a wc -l command on source and target, executed through Execute Command activity in sequence or DSExecute in job control routine.

my question is like when i created a job sequencer for 5 flat files which i am using with job activithy stages how can i get record count should get the record count .iam asked to create a control job for this purpse.
Thanks
sunitha

If you want to get the number of records processed in the job then After job routine would do fine.Remember few records could be rejected at stage level for such issues this is a better option.


Or If you just want the count of records from source and target files then wc -l suggested above is the best option .

To count the number of records in each file, you can use File Name Column property of sequential stage and then using aggegate by grouping on file name, you can count the records in each file.

Hi Nirdesh,

could you please explain in detail.

SeqFileStg1----->Funnel-------->Aggregate Stage(Aggregate on File Name)
SeqFileStg2
SeqFileStg3

That would be a "PX specific" solution and not applicable to a Server job, unfortunately.