Container in DataStage

Container in DataStage

• It is a reusable Component

Container are of Two types

1. Local container  job Specific
2. 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