Hi,
I have a job (Job A) in which a huge query fetches data from a database thru a db2 stage then transforms and sends transformed data to an xml. Now, i have a requirement (Job B) to get all the data that was in earlier job plus a lot more i need to fetch from the db2 database.
I was planning to make use of Job A. Probably, use the db2 stage into a shared container and use that in both Job A and Job B. Is that something achievable through shared container? I've been trying for it but not sure how to get that done. My idea is to run the query on db2 only once and make the data available for both the jobs.
Please suggest me.
Regards,
Reyaz
using shared container
Moderators: chulett, rschirm, roy
No. A shared container is just a chunk of reusable code / job design and won't faciliate the sharing that you need. Can't you have the first job 'land' the data such that the second job could leverage it without having to redo all the work?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers