In general , we have 4 Architecture
2.ODS – Operations Data source
3.NDS – Normal Data source
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
- ODS –à80% ODS Model
- WHY ODS ?
Sol :- when Business Requirements are defined, click / customer requests the team what be want exactly.
Project 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)
Pull You get (take) the data
Push he 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.
LoadingStaging ODS Ware housing Box size of 100 Tear loading
10 TB loading
30 TB Staging
60 TB Ware 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