can i use other two effective dates column in SCD2

[sharvan.kumar.83@gmail.co]

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

[ngalemmo]

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.