10 October, 2020
In general, we have 4 Architecture
we can implement this Architecture either in Inmon 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
Sol:- when Business Requirements are defined, click/customer requests the team what we want exactly
Project Architecture depends on no. of operational and Analysis Reports.
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.
Inclined to build a profession as DataStage Developer? Then here is the blog post on, explore Datastage Training
Loading, Stage, and warehouse is a Single Data stage.
LoadingStaging ODS Warehousing Box size of 100 Tear loading
10 TB loading
30 TB Staging
60 TB Warehouse.
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;
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 .