create control jobs to get the record count in the target

sunitha_cts · Post by **sunitha_cts** » Tue Jun 30, 2009 10:43 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Jun 30, 2009 10:46 pm

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.

sunitha_cts · Post by **sunitha_cts** » Tue Jun 30, 2009 11:18 pm

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

elias.shaik · Post by **elias.shaik** » Tue Jun 30, 2009 11:33 pm

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 .

nirdesh2 · Post by **nirdesh2** » Tue Jun 30, 2009 11:54 pm

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.

elias.shaik · Post by **elias.shaik** » Wed Jul 01, 2009 12:06 am

Hi Nirdesh,

could you please explain in detail.

nirdesh2 · Post by **nirdesh2** » Wed Jul 01, 2009 12:52 am

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

chulett · Post by **chulett** » Wed Jul 01, 2009 6:00 am

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