Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

SCD or data in FACT TABLE

2 posters

Go down

SCD or data in FACT TABLE Empty SCD or data in FACT TABLE

Post  MK Wed Feb 13, 2013 8:53 am

Hi,

We have certain codes (dimensions) that have expiration date.
In my opinion, these are the scd dimensions. The FACT table
would be based on the foreign key, and get a real date information.
And also this will help as to trace the history.
Now associate wants that dimenzion table do not need the expiration date
and through field (fk) in the FACT table we will know the real codes that
hapened in the time when transection appears.

Is that realy the right way, what is your opinion, thanks in advance, Km

MK

Posts : 16
Join date : 2013-02-04
Location : Slovenia

Back to top Go down

SCD or data in FACT TABLE Empty Re: SCD or data in FACT TABLE

Post  chade25 Wed Feb 13, 2013 8:48 pm

It depends on the business. I have seen some source tables where they had effective dates and seemed type 2 but were not because the most recent record better describes all the data even in the past, so , in that case I was able to keep it a type 1. In another case I was not able to because for anything that is NOT the FK and changed, it would update, therefore saying something that was NOT true at the time of the past event and in this case I want a type 2...but even in other cases I was able to take a source table and split some of it into facts to keep the dimension a type 1 and have the ETL logic write the fields to the fact table and supply the correct FK from the dimension to the fact.

chade25

Posts : 29
Join date : 2012-04-12
Age : 42
Location : Oregon

Back to top Go down

SCD or data in FACT TABLE Empty RE : SCD or data in FACT TABLE

Post  MK Thu Feb 14, 2013 8:25 am

Thanks for all explanation. This will help me,

Best regard, K

MK

Posts : 16
Join date : 2013-02-04
Location : Slovenia

Back to top Go down

SCD or data in FACT TABLE Empty Re: SCD or data in FACT TABLE

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum