mobileNavlogo
headerlogo

Project Architecture in DataStage

Blog Author

Tekslate

Published Date

10th October, 2020

Ratings

Views

519

  • 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

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

About Author
Authorlogo
Name

TekSlate

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 .

Related Blogs

Write For Us