In general , we have 4  Architecture


2.ODS  - Operations Data source

3.NDS – Normal  Data source



11 we   can implement these Architecture  either in In mon 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





In mon Models is preferred when Requirements are very clear.

Kim bell Model is preferred when   Requirements are not clear.


With respect  to project  , we deal with

  1. ODS --à80% ODS Model


  1. WHY ODS ?

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




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

  • More priority is given to operational and Analysis Reports
  • Is 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 ware house and Data marts (NDS).
  • ODS gets refreshed for 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 :-



To validate the files according to Quality  Gates.


These core tutorials will help you to learn the fundamentals of DataStage .

For an in-depth understanding and practical experience, explore Online DataStage Training.


Loading, Stage and ware house  is an Single Data stage.

Loading11Staging  ODS 11 Ware housing  11Box size of 100 Tear loading


10 TB 11 loading

30 TB 11Staging

60 TB 11Ware house.


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