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

SCD dimension

2 posters

Go down

SCD dimension Empty SCD dimension

Post  MK Thu Mar 14, 2013 2:22 pm

Helou,
I have two dimension where I need handle the changes. I read that we can do this with validation dates or we can use
a version row (fk pk data data data version 0 , fk pk data data data version 1) and than we use fk.
My co workers ant to handle changes in a way I do not like.

FAct table
Primary keyof persons, serial number, other data...

Dimension of persons
Primary key name, surname, gender, serial number

Dimension
10, John, Kine, M, 01
10, John, Zupan, M, 02
11, Jane, Coop, F, 01

.... Thanks K

MK

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

Back to top Go down

SCD dimension Empty Re: SCD dimension

Post  ngalemmo Thu Mar 14, 2013 7:22 pm

Usually you use a timestamp instead of a version number. The problem with version numbers is you need to figure out what the last one was to set the new one. You will also need a 'current' flag to identify the most current row.

Also the surrogate PK is different on each row.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

SCD dimension Empty SCD dimension

Post  MK Fri Mar 15, 2013 7:12 am

Hi,

Thanks for your replay, they said that on event day from fact table will be in the same row key of the person and the verzion number.
From dimension of person we will take the max version. I do not know how to explain them, that the standard method (fk in fact table and
date (or timestamp) from where is valid that is better way.

Thanks again for all your help, K

MK

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

Back to top Go down

SCD dimension Empty Re: SCD dimension

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