Beginning Data Modeling for DW

raghuk at 19h34
19
Jun
2009
Beginning Data Modeling for DW

Hello,

Please bear with me as these are a beginner's struggle to implement the DW the best way possible. I recently started studying about Kimball modeling.

I would like to ask a few questions on common practices on modeling the DW. I need to store historical data all the time; and I'm thinking I should use SCD2.

The following are a few tables. I just need a little help grouping them into a fact/dim categ
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1842
  • Numbers of messages : 8656
  • Numbers of users : 3787
  • Numbers of points : 1497
Similar topics
Chào các bạn ^^, mình là chủ của Paruce Shop. Paruce là shop online duy nhất tại VN có thể mua hàng chính hãng và bán giá do cty phân phối đĩa Hàn Quốc cung cấp. Sau cơn sốt JYJ vừa qua, chắc hẳn nhìu bạn còn tiếc nuối vì chưa sở
Hi, this is my first post to this forum so please be nice! hehe I'm at the beginning of a fairly large DWH project (by Norwegian standards) and I have been reviewing data modeling tools recently. However, there seems to be a general lack of support
I'm trying to figure out how to best model a DataWarehouse Star Schema structure to capture certain medical information that will answer the questions we ask. First the questions to put in some context: 1) How many distinct patients had a BMI in the
Uploaded by PaulRevere2012 on Aug 17, 2010 2011 -- The beginning of the End of America - Double Dip Recession turns into 10 year Depression - The United States begins its decent from prosperity to economic stagnation / depression in 2011 as the
Hello there, Considering the case that i am assigned to work on, which is to decide on the most appropriate schema to be chosen for the Data Warehouse / Business intelligenece Project. First of all, i would like to know the available options for me,
Forums from same category
See also
more_less
Informations

4 Replies For the topic :
"Beginning Data Modeling for DW"

This topic has been viewed 1092 times.

Last message :
19/06/2009 at 19h34 by "raghuk"