Group Discounts available for 3+ students and Corporate Clients

Architecture of Data Stage


Repository :- / Work Area / Project

It is a work Area with collection of different Components.

  • Different Repository Components are
  • Table Definition
  • Shared Contains
  • Routines ..etc
  • Jobs


It is an Environment for developing ETL jobs using the components.

Engine :- /Data stage Server

  • Responsible for Executing Data stage jobs.
  • Engine is also Responsible for partitioning, Re- partitioning and Reverse partitioning.

Plugins are used for communication with external sources or target



  • Though interface, the local of oracle are added to the Data stage
  • Plug – ins will reside in package Installer


We need to install Data stage packages using packes of package Installer



  • Designer
  • Director
  • Manager
  • Admin



  • Repository
  • Engine
  • Package Installer
  •  client
  • Designer
  • Director
  • Manager
  • Admin



Common user interface :- / unified users:

  • Designer
  • Director
  • Web console
  • Admin
  • Information Analyzer



  1. Common repository : / Meta Data Server

Common Environment  to store w. r. t. Data Quality Data profiling and data Transformation.

  1. Common Engine :-

Responsible for information Analysis , Data Quality and data Transformation.

  1. Common Connectivity:-

Responsible for plug ins  and packs.

  1. Common Shared Services :–

Acts as interface between all components



         2 – layer Architecture




– – >  W – H Inman is known as the faster of warehouse .

– – > Top – bottom approach was given by W – H Inman.

– – >Bottom – up approach was given by Ralph – Kimball.



Aspired to become an DataStage?
Explore the post to discover the know-hows on DataStage Training.

L4  Project Architecture



Different format of .txt

– – >  Fixed width flat files

– – >   Comma separated values

– – >  Variable length files

– – >   Head and tail files



For indepth understanding of DataStage click on


“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on Architecture of Data Stage"

Leave a Message

Your email address will not be published. Required fields are marked *


Please Enter Your Details and Query.
Three + 6