Page 1 of 1

Control Table in datastage?

Posted: Fri Mar 28, 2014 3:01 am
by A_SUSHMA
Hi All,

what is Control table in data stage and how it works ?

If possible Please explain me with example..

Posted: Fri Mar 28, 2014 4:05 am
by ray.wurlod
There isn't one.

If there is, it's something YOUR developers/designers have implemented. It is they, therefore, who need to do the explaining.

Posted: Sat Mar 29, 2014 5:57 am
by A_SUSHMA
Hi All,

I have two jobs,In this I need to execute second job from First job. Means to Execute one job from other job.

Please explain me how can i do in datastage...

Posted: Sat Mar 29, 2014 7:41 am
by chulett
Still not a control table.

If you need to run the two jobs in a particular order one after the other, that's what a Sequence job would let you do. If you need one job to run another, you'll need to be more explicit as to what exactly that means.

One time thing? Technically you can use dsjob from the After Job area of the first job but you're better off using a Sequence for that. Need to run the second job once for every row the first one processes, perhaps even passing row data from the first job to the second as parameters? That's what DSUtilityRunJob is for.