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

Bitemporal vs SCD

4 posters

Go down

Bitemporal vs SCD Empty Bitemporal vs SCD

Post  TheDarkKnight Fri Mar 22, 2013 3:27 pm

can anyone really present the difference between Bitemporal architecture vs the SCD2.
why is the one better than the other?
TheDarkKnight
TheDarkKnight

Posts : 10
Join date : 2013-03-22
Age : 39
Location : NJ

Back to top Go down

Bitemporal vs SCD Empty RE: Bitemporal vs SCD

Post  rathjeevesh Mon Mar 25, 2013 12:07 am

SCD type 2 is driven by surrogate key concept which is a primary key for the dimension table. Historical information about the dimension can be easily stored and retrieved using SCD 2 technique.

Bitemporal design approach will add lot of complexity while handling dimension to fact relationship. Either all queries need to have a restriction of which record you want to retrieve (current/history) or you need to have a multipart (composite) primary key foreign key relationship from dimension to fact. Else there is every possibility of having many to many relationships between dimension & fact.

Thus using SCD 2 technique in DW is effective and it is a key differentiator between Kimball & Inmon approach.

-JR

rathjeevesh

Posts : 15
Join date : 2013-02-16

Back to top Go down

Bitemporal vs SCD Empty Re: Bitemporal vs SCD

Post  BoxesAndLines Mon Mar 25, 2013 8:24 pm

Sure, with bi-temporal you have two sets of dates. One set for the business effectivity. One set for dw effectivity.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Bitemporal vs SCD Empty Re: Bitemporal vs SCD

Post  temporalcraig Sat Mar 30, 2013 2:02 pm

you may also find a couple other previous threads on this forum helpful.:

http://forum.kimballgroup.com/t1776-using-bitemporal-dimensions-to-show-corrections

http://forum.kimballgroup.com/t990-bi-temporal-as-at-reporting

craig

temporalcraig

Posts : 10
Join date : 2010-07-19
Location : Princeton, NJ

http://www.bitemporaldata.com

Back to top Go down

Bitemporal vs SCD Empty Re: Bitemporal vs SCD

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