SCD dimension

View previous topic View next topic Go down

SCD dimension

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

View user profile

Back to top Go down

Re: SCD dimension

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

SCD dimension

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

View user profile

Back to top Go down

Re: SCD dimension

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