Can you guys Please help me with this scenario.
Code: Select all
DRS_Stage
|
|
|
|
|
V
Sequential_File ----->JOIN_Stage---------->Sequential_File
Here the input source file, the schema of the input file, the output file, the columns from the DB stage all are same.
The only difference in them is in the key which is used to join. In the ten jobs I use ten different columns to join the data.
I was thinking of implementing it using a single job and parametrizing the key column name in the join stage. Is that possible?. And if we can parametrize, Can we use multiple instances of job?
Or do I need to create copies of the job and change the key column names in all the jobs.......
I really appreciate your help.
Thank you :D