Parameterizing output of Job
Posted: Thu Mar 22, 2007 7:55 am
HI,
I am having a scenario like this.
1. Query Oracle Table to get A Date field and keep it as a parameter
2. Use the above parameter in a Where clause when I query Redbrick Tables to get the required columns
As the two table reside in difffernt schemas one in Oracle and anothere in Redbrick I cannot do a join. Options I thought
1. Pass on the Oracle datefield to a sequential file and Open and read it to a parameter before the 2nd job which queries Redbrick and use it in the parameter in the User defined sql
2. Unload Table from Oracle into Redbrick as a work Table.. Work in this table. Do whatever insert/update/delete i have to do and at the end load it back to Oracle. But this is like maintaining a mirror table so i left the idea
I went ahead with the #1 approach but felt it to be a bit lengthy and round about way . Is there any way I can pass a run time value to a parameter in DataStage.
e.g Defined #Datetime# in DSAdmin with some default value and when the first job querying Oracle runs the Output is assigned to #Datetime# parameter and i can use it in later jobs
I am having a scenario like this.
1. Query Oracle Table to get A Date field and keep it as a parameter
2. Use the above parameter in a Where clause when I query Redbrick Tables to get the required columns
As the two table reside in difffernt schemas one in Oracle and anothere in Redbrick I cannot do a join. Options I thought
1. Pass on the Oracle datefield to a sequential file and Open and read it to a parameter before the 2nd job which queries Redbrick and use it in the parameter in the User defined sql
2. Unload Table from Oracle into Redbrick as a work Table.. Work in this table. Do whatever insert/update/delete i have to do and at the end load it back to Oracle. But this is like maintaining a mirror table so i left the idea
I went ahead with the #1 approach but felt it to be a bit lengthy and round about way . Is there any way I can pass a run time value to a parameter in DataStage.
e.g Defined #Datetime# in DSAdmin with some default value and when the first job querying Oracle runs the Output is assigned to #Datetime# parameter and i can use it in later jobs