Page 1 of 1
Posted: Thu Sep 10, 2015 5:58 am
by vamsi_4a6
1)Get the distinct values in column1 using unix or datastage.Write them into some text file.
2)use looping in jobsequence to iterate for each value present in text file.withinlopping pass the value as parameter to jobactivity
Posted: Thu Sep 10, 2015 7:07 am
by chulett
I seem to recall this being added as a feature in one of the later versions of DataStage... can anyone confirm / deny?
Posted: Thu Sep 10, 2015 7:34 am
by qt_ky
Good memory, Craig!
Please see my post on
this topic.
Posted: Thu Sep 10, 2015 8:13 am
by JPalatianos
Thank You everyone for your suggestions! When using the "Generate Multiple file" option using a key do you know the default directory where the output files get written too?
Posted: Thu Sep 10, 2015 8:26 am
by qt_ky
As with any use of the Sequential File stage, it will place the file(s) in whatever path you specify. We normally prefix every file name with a parameter which holds the value for the path. If you don't specify a path, then the file(s) will be written into the DataStage project path, mixed in with all the system files for your job designs, etc. The default is not usually the best place for your data files.
Posted: Thu Sep 10, 2015 8:28 am
by JPalatianos
Perfect..This solution works perfectly!
Thank You All!!