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 edit
Construct – container
Local
- 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 set
We want to use this output is n no. of jobs
- Select the whole job
Edit
Construct container
Shared
Save 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 output
Res
properties
output
select out
Load
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