Advice on relationships between Type 2 SCDs ?

Andy at 18h30
24
Jan
2011
Advice on relationships between Type 2 SCDs ?

Hi All,

I am constructing a new warehouse schema containing a number of dimensions which need to be modeled as type 2 SCDs. This is all fine and I have surrogate IDs which are being used as the FK in the facts. The challenge I have is that a number of the SCDs have relationships between them which need to be maintained to support other workflow aspects. Holding multiple versions over time makes all these relationships M:M wh

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
rationale behind dimension with Type 0 and missing Type 5
Can anyone explain in detail on what is the rationale behind having the dimension start with Type 0 and also for the missing type 5
Updating a Fact Table
I currently working on an Accounting Datamart which the dims and facts are loaded daily. I have recently had a request to update the data after its been loaded. The best way for me to explain this is to give an example. The data is loaded daily, so
Does a SCD Type 1 Change Response Always Update All Historical Records?
Often when implementing slowly changing dimensions, a particular dimension will have only certain columns that are interesting to view changes over time (Type 2) while the remainder simply need to be updated (Type 1). Given this combination of Type 2 and
Multiple Many-To-Many relationships
I've read quite a bit on dimensional modeling but this would be my first go in reality. Any help would be greatly appreicated. Here's what I've got... An existing subset of our DW would be: Fact_tx Dim_Customer Dim_Product One of our source
Dimensional Modelling when the core concept has Many to Many relationships (or am I trying to fit a square peg into a round hole)
I am currently building a product to help do analysis of content management systems. The product is feeling very much like a DataWarehouse/datamart system, and I'm trying to apply dimensional modelling techniques to the model. After reading the first fe
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"Advice on relationships between Type 2 SCDs ?"

This topic has been viewed 917 times.

Last message :
24/01/2011 at 18h30 by "Andy"