• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Project Architecture in DataStage

In general , we have 4  Architecture

1.Simple

2.ODS  – Operations Data source

3.NDS – Normal  Data source

4.Integrity

 

11 we   can implement these Architecture  either in In mon Model or Kimball Model

Top to bottom                                Bottom to top

Screenshot_110

 

Universally  –   8 Architecture

Inmon – Simple, ODS,  NDS, Integrity

Kimbell – Simple, ODS,  NDS, Integrity.

Simple

SRC —- WH

Screenshot_111

 ODS

Screenshot_112

 

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

2.NDS

  1. WHY ODS ?

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

 

Screenshot_113

 

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)

 

Screenshot_114

 

 

Architecture

Screenshot_115

 

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 :-

Screenshot_116

Script 

To validate the files according to Quality  Gates.

Screenshot_117

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

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

 

Screenshot_118

 

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

For indepth understanding of DataStage click on

Summary
Review Date
Reviewed Item
Project Architecture in DataStage
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Project Architecture in DataStage"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.