Loop Activity
Posted: Sun Apr 02, 2006 3:04 pm
Dear All,
Would like to have your suggestion for the below scenario.
Source table has the following structure and data
Geo_Name, Geo_Ds, Cntry_Cd
'ABC','ABC','FI'
'DEF','DEF','FI'
'ASD','ASD',DK'
The target table is country specific like Geo_#Cntry_Cd#
I have a DS Job which has Cntry_Cd as a parameter and selects only country specific data from the source and inserts into the specific target table. I have set this job as a multi instance job
I am done till this. I am a bit struck when it comes to including this job in a sequencer. I want to sequence this in such a way that If there are 'n' distinct country codes in the source, this job has to run for 'n' instances each selecting the respective countries data and inserting into the respective countries table. Also I want to run all these jobs in parallel.
Assuming that I know the country codes for which I need to process, I designed a sequencer job which uses loop activity. I hard coded the two country codes in the list of the loop activity. The sequence successfully triggers the job twice but it does sequentially. How can I achieve parallel processing of these jobs?
And if I need to arrive at the country codes while executing rather than hard coding in the loop activity, how can I achieve it?
Thanks, Pal.
Would like to have your suggestion for the below scenario.
Source table has the following structure and data
Geo_Name, Geo_Ds, Cntry_Cd
'ABC','ABC','FI'
'DEF','DEF','FI'
'ASD','ASD',DK'
The target table is country specific like Geo_#Cntry_Cd#
I have a DS Job which has Cntry_Cd as a parameter and selects only country specific data from the source and inserts into the specific target table. I have set this job as a multi instance job
I am done till this. I am a bit struck when it comes to including this job in a sequencer. I want to sequence this in such a way that If there are 'n' distinct country codes in the source, this job has to run for 'n' instances each selecting the respective countries data and inserting into the respective countries table. Also I want to run all these jobs in parallel.
Assuming that I know the country codes for which I need to process, I designed a sequencer job which uses loop activity. I hard coded the two country codes in the list of the loop activity. The sequence successfully triggers the job twice but it does sequentially. How can I achieve parallel processing of these jobs?
And if I need to arrive at the country codes while executing rather than hard coding in the loop activity, how can I achieve it?
Thanks, Pal.