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

Architecture  

Universally  -   8 Architecture

Inmon – Simple, ODS,  NDS, Integrity

Kimbell - Simple, ODS,  NDS, Integrity.

Simple

SRC ---- WH

Simple Architecture

 ODS

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

WHY ODS?

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)

  ODS    

Architecture

Architecture  

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

Script 

To validate the files according to Quality  Gates.

Script

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

Loading

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

  Loading  

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

For an in-depth understanding of DataStage click on