Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CIF Approach
- Thread starter monsky
- Start date
johnherman
MIS
I have been involved in CIF approaches. It will work quite well if there is a reasonably good Enterprise Data Model or if time is taken to build one. Without a good Enterprise Data Model, there will be problems, similar to those which would arise if you didn't build the Dimension Bus Matrix in the Kimball methodology.
Kimball purists would argue that considerable disk space is wasted building a 3NF Data Warehouse at granular level before building out the data marts. Generally, I agree, although there are applications where the 3NF Data Warehouse can be useful, for instance, real time Data Warehousing where the 3NF warehouse is populated by near-real-time replication from transactional or ODS systems.
-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
Kimball purists would argue that considerable disk space is wasted building a 3NF Data Warehouse at granular level before building out the data marts. Generally, I agree, although there are applications where the 3NF Data Warehouse can be useful, for instance, real time Data Warehousing where the 3NF warehouse is populated by near-real-time replication from transactional or ODS systems.
-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
- Status
Similar threads
- Locked
- Question