Container in Data Stage

Container

• 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 For indepth understanding of DataStage click on

• Introduction to DataStage
• Architecture of Data Stage
• Oracle Enterprise in Data Stage
• SCD(Slow changing Dimension) in Data Stage
• DataStage Tutorials