DSXchange

Hello Ray, Imagine if there are 100 tables with each table linked to say 10 or more with refrential integrity constraints. In this case if we do it in Datastage, and if in future we add one more table, which will link to those 10 + tables, we will need to recode / enhance all existing interfaces. On...

Hello Ray, Imagine if there are 100 tables with each table linked to say 10 or more with refrential integrity constraints. In this case if we do it in Datastage, and if in future we add one more table, which will link to those 10 + tables, we will need to recode / enhance all existing interfaces. On...

Ok Have started writing it (our developer not me ). We already have job control which sets params for a job and runs it. So will change it to use arrays, load array with job names and params and then do the looping part.

Will post it here once done.

Thanks

You can also create a job sequence with N streams of job activities. This will restrict execution to at most N jobs at a time. Job1 ----> Job5 ----> Job9 ----> Job13 ----> Job17 ...[/quote] Hi Ray, This is what we are doing today, running N jobs in parallel and then waiting for status from all thos...

Thanks, now I am waiting for access to the website. Looks like they review my profile?? before granting me access to their publications and utilities.

Regards

Thanks a lot for the reply. Can you guide me as to where can I find those utils?

Thanks
Preetinder

Hi, We have around 30 jobs which load data to teradata. When we run all in parallel (not PX plain parallel) we end up with resource issues. Currently we run them in parts of 5 jobs each in parallel and then next and next. Does someone has an idea how to write job control/routine for below - Input - ...