Having control file in a px parallel job output stage?

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
kruthika
Participant
Posts: 21
Joined: Mon May 31, 2004 11:14 pm

Having control file in a px parallel job output stage?

Post by kruthika »

Hi,

Can i have a control file which gives me information like how many rows are processed through particular link,job status,where it is stored(path),...etc in a px parallel job output stage?

Also i want to extract that data.Is there any way to extract that data.

Regards,
Kruthika
Kruthika
richdhan
Premium Member
Premium Member
Posts: 364
Joined: Thu Feb 12, 2004 12:24 am

Post by richdhan »

Hi,

Either you can use the Tail stage to get the required output on to a sequential file or you can use the Transformer, Aggregator and job parameters to get the number of records processed, the path and the
other details.

There are different methods of doing this. If you can search the forum you will get more information.

But Iam not sure whether you can get status of the current job from within the job since the job will be in running status.

Once the output is there on a flat file you can very well extract the data.

HTH
--Rich
kruthika
Participant
Posts: 21
Joined: Mon May 31, 2004 11:14 pm

Post by kruthika »

Thanks for ur response.
Ur explanation is very clear,I will try the way u said.
Kruthika
Post Reply