can i use other two effective dates column in SCD2
2 posters
Page 1 of 1
can i use other two effective dates column in SCD2
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
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
Re: can i use other two effective dates column in SCD2
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.
Similar topics
» Combination of SCD2, partial snowflake, Effective and end dates in fact table
» Loading dimension when source already has effective to and from dates
» Dimensions with effective and end dates - best design and best way to join to fact tables?
» Best practice for SCD2 start and end dates
» snapshot facts: daily versus effective from & to
» Loading dimension when source already has effective to and from dates
» Dimensions with effective and end dates - best design and best way to join to fact tables?
» Best practice for SCD2 start and end dates
» snapshot facts: daily versus effective from & to
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|