Container
- It is a reusable Component
Container are of Two types
- Local container
job Specific - Shared container project Specific
Local Container
Used for minimizing the complexity and can only be used in a job.
- Select Some part in the job Click editConstruct – containerLocal
- It gets packed in to a single box called container
Container Data set
Container Data set
Right Click De construct (gives original pattern back)
Shared Container
- These are reusable components used with in the project
Oracle Transformer Data setWe want to use this output is n no. of jobs
- Select the whole jobEditConstruct containerSharedSave it
To use this output, in other job
Open Container Select the shared Container Drag and drop
Interested in mastering DataStage?Learn more about DataStage Tutorial in this blog post.
Oracle Transformer Container outputRes properties output select outLoad reconcile from container link
Shared container used in an Surrogate key
When we have Surrogate key Generator in different jobs, we replace it using an shared container.
Both Jobs are loading output in to same Target Table
Rather taking multiple Surrogate keys, Select it and make it as container
There will be Co-ordination between all Surrogate keys
No need to write the functionality again and again
For indepth understanding of DataStage click on