Project Architecture in DataStage
  • Share this blog:

In general, we have 4  Architecture

  • Simple
  • ODS  - Operations Data source
  • NDS – Normal  Data source
  • Integrity  

11 we can implement this Architecture either in Inmon Model or Kimball Model

Top to bottom                                Bottom to top


Universally  -   8 Architecture

Inmon – Simple, ODS,  NDS, Integrity

Kimbell - Simple, ODS,  NDS, Integrity.


SRC ---- WH

Simple Architecture


ODS Architecture  

  • Inmon Models are preferred when Requirements are very clear.
  • Kim bell Model is preferred when   Requirements are not clear.  
  • For the project, we deal with
  1. ODS --à80% ODS Model
  2. NDS


Sol:- when  Business Requirements are defined, click/customer requests the team  what we want exactly

.   ODS  

11Project Architecture depends on no. of operational and Analysis Reports.

  • More priority is given to operational and Analysis Reports
  • Are we have more operational Reports we use ODS.
  • Less operational Reports and more Analytical Reports, we use NDS.
  • In NDS, we can’t See ODS, But in ODS, we can find warehouse and Data marts (NDS).
  • ODS gets refreshed every 10 seconds.
  • ODS dim Table will always be type 1 (No History)




Data Acquisition 

Pull  11 You get  (take) the data

Push 11he sends the data

DRA:-  Data Repository Area

CSA:- Common Staging Ares

DRA:- Will get only files  -    Memory which is accessed by different departments.

Data Query:-   When the  data is being such  what the data should contain

Quality Gates:-  Requirements .

Every file should have a specific file name:-

Control info


To validate the files according to Quality  Gates.


Inclined to build a profession as DataStage Developer? Then here is the blog post on, explore Datastage Training


Loading, Stage, and warehouse is a Single Data stage.

Loading11Staging  ODS 11 Warehousing  11Box size of 100 Tear loading  

10 TB 11 loading

30 TB 11Staging

60 TB 11Warehouse.  

Dumping the data from DRA to loading à a copy of data


When we load Data to Target data, We maintain all details, that is sequence no;

For an in-depth understanding of DataStage click on

About Author
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.