can i use other two effective dates column in SCD2

View previous topic View next topic Go down

can i use other two effective dates column in SCD2

Post  sharvan.kumar.83@gmail.co on Mon Nov 24, 2014 5:57 pm

Hi,

I have source data that is coming with records effective begin date and effective end date e.g.. ( Null means active)
Salesperson Region SalespersonName Effective begin date Eff_end date
x01 Jhon 1/1/2014 NULL
xo2 Shyam 1/30/2014 6/5/2014

now i want to implement the scd2 if any of the attribute change ( region, name begin date , and end date) I would insert new records with current flag.

so my question is will is use the another scd_eff_begin date scd_end_date and flag along with flag?
let us assume we are loading the data on 1/15/2014
Dimension table --
Salesperson Region SalespersonName Effective begin date Eff_end date Scd begindt scdenddt Flag
x01 Jhon 1/1/2014 NULL 1/15/2014 12/31/999 Y
xo2 Shyam 1/30/2014 6/5/2014 1/15/2014 12/31/999 Y

later on same data set was update on 1/17/ 2014. so my dimension looks like..

Salesperson Region SalespersonName Effective begin date Eff_end date Scd begindt scdenddt Flag
x01 Jhon 1/1/2014 NULL 1/15/2014 1/16/2014 N
x01 Jhon 1/1/2014 1/14/2014 1/17/2014 12/31/999 Y

xo2 Shyam 1/30/2014 6/5/2014 1/15/2014 1/16/2014 N
xo2 Kevin 1/30/2014 12/31/2014 1/17/2014 12/31/999 Y

so my question is will is use the another scd_eff_begin date scd_end_date and flag along with flag?
how do i interpret source columns dates as the source coulmns dates says records are not active ( x01 -1/14/2014) but the scd columns this is active records.

Please guide me.

Thanks



sharvan.kumar.83@gmail.co

Posts : 10
Join date : 2014-11-17

View user profile

Back to top Go down

Re: can i use other two effective dates column in SCD2

Post  ngalemmo on Mon Nov 24, 2014 6:49 pm

They are two different sets of dates for two different purposes. The SCD timestamps are there to record when things occurred in the data warehouse while the others record what occurred in the source system. The source system dates are attributes, treat them as such.
avatar
ngalemmo

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

View user profile http://aginity.com

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