How to propagate the change in table definition to all jobs
Posted: Wed Jun 27, 2012 1:57 pm
Hi,
I have a situation, wherein i am extracting the data from a table into a staging file and doing the following -
1. I saved the table definition for this staging file.
2. This staging file is being used in 20 more jobs for different funcationalities.
3. All these 20 jobs are reading the file with the saved table definition.
4. If i need to change one field in the table definition, do i need to the update all 20 jobs to change the table definition. Is there a way it can be updated in all the jobs dynamically.
Any Help will be appreciated much!!
Thanks,
Vishal Gupta
I have a situation, wherein i am extracting the data from a table into a staging file and doing the following -
1. I saved the table definition for this staging file.
2. This staging file is being used in 20 more jobs for different funcationalities.
3. All these 20 jobs are reading the file with the saved table definition.
4. If i need to change one field in the table definition, do i need to the update all 20 jobs to change the table definition. Is there a way it can be updated in all the jobs dynamically.
Any Help will be appreciated much!!
Thanks,
Vishal Gupta