we have many changes on our source and target, and we have about 200 jobs running in production for at least one year back.now we have to apply those changes to the jobs to reflect the new added columns to the source and target.
what is best approch to make those changes to the ETL jobs and metadata, and if there any tools helping doing that(metadata).
any help will be very appreciated
source and target chaged
Moderators: chulett, rschirm, roy
Just use proper SDLC methodologies, do impact analysis and rigorous testing. The Designer is easy to use, there's really no issue involved other than straight development and testing.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Usage Analysis is probably the first thing you need to do. Select each of the affected table definitions and use Usage Analysis to learn which jobs touch each of them. (If you have not been systematic with loading imported/saved table definitions in jobs, then Usage Analysis may not find all jobs; in this case you will need to query DS_JOBOBJECTS: search the forum for techniques.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Purchasing a paid membership is well worth the investment! It costs pennies a day, is much cheaper than a support call, and most companies will cover the cost for you if you show it is an oft used resource. If they won't pay for it, you can write it off of your own taxes.
Please consider it!
Bestest!
Please consider it!
Bestest!
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"