There are two most commonly approaches in DWH architecture introduced by Bill Inmon and Ralph Kimball.
Bill Inmon -> Top-Down Approach
According to Bill Inmon, first make a normalized data model (ware house) then split into data marts.
Dimensional data marts are created only after the complete data warehouse has been created.
To built data ware house it will take more time compare to Ralph Kim-ball approach. Client requirement should be fixed before start of development.
Ralph Kimball -> Bottom-Up Approach
Ralph Kimball says "The data warehouse is nothing more than the union of all the data marts"
It means, first create data marts and then make a schema relation.
Dimensional data marts (Di mention and Fact table) provide a narrow view into the organizational data, then they related by start or snow flex schema based on requirement.
To built data ware house it will take less time compare to Bill Inmon approach. Client requirement need not be fixed before start of development.
No comments:
Post a Comment