SCD or data in FACT TABLE

View previous topic View next topic Go down

SCD or data in FACT TABLE

Post  MK on 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

View user profile

Back to top Go down

Re: SCD or data in FACT TABLE

Post  chade25 on 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 : 37
Location : Oregon

View user profile

Back to top Go down

RE : SCD or data in FACT TABLE

Post  MK on 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

View user profile

Back to top Go down

Re: SCD or data in FACT TABLE

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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