W.H.Inmon & Ralph Kimball Approach Part-3 - ETL- iNFORMATICA DEVELOPER

Thursday, May 23, 2019

W.H.Inmon & Ralph Kimball Approach Part-3

ktnewslive


Top Down Approach



1- Top Down Approach or Dependent Data Marts (W.H.Inmon)


          According to W.H.Inmon first we need to design an EnterpriseData warehouse then design a small form of Subject Oriented .

Department design specific DB known as Data Marts









2-Bottom-Up Approach or Independent Data Marts (Ralph Kimball)



      According to Ralph Kimball first we need to design department specific database known as Data Marts then integrate all data marts into Enterprise Data Marts.






Datawarehouse Vs Datamarts






1 comment: