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

 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.

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

L₄  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

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