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
Packs
We need to install Data stage packages using packes of package Installer
Client
Components
 Designer
 Director
 Manager
 Admin
 Server
  Repository
  Engine
  Package Installer
  client
  Designer
  Director
  Manager
  Admin
 8.0.1:
 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.
2. Common Engine :-
 Responsible for information Analysis , Data Quality and data Transformation.
3. Common Connectivity:-
 Responsible for plug ins and packs.
4. Common Shared Services :--
 Acts as interface between all components
1. Common repository : / Meta Data Server
Common Environment to store w. r. t. Data Quality Data profiling and data Transformation.
 Architecture
 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.
s