3 Replies Latest reply: Dec 9, 2012 8:27 AM by Satti Aluri RSS

    How can I implement SCD w/ only 1 table as source?

      Hi,

       

      I'll attach a sample excel file having records below,

       

      Employee IDEmployee NameGenderStatusDate Hired
      E-2012-0001Zac EfronMaleSingle1/14/2012
      E-2012-0002Selena GomezFemaleSingle1/15/2012
      E-2012-0003Channing TatumMaleSingle2/15/2012
      E-2012-0004Amanda SeigfredFemaleSingle3/2/2012
      E-2012-0005Beyonce KnowlesFemaleMarried3/3/2012
      E-2012-0006JoJoFemaleSingle3/5/2012
      E-2012-0007Jesse McCartneyMaleSingle4/2/2012
      E-2012-0008Mariah CareyFemaleMarried4/2/2012
      E-2012-0009Brian McKnightMaleMarried4/2/2012

       

      That is the only table, but how can I know, if one of the employees changes the STATUS from SINGLE to MARRIED?

      How can I track changes or apply the SLOWLY CHANGING DIMENSION?

       

      Please help asap. I need this to track as of dates reports.

       

      ==================================================================

      Say for example,

       

      As of June 6, 2012 Zac Erfron is Single, but as of Aug 1, 2012 he's Married. reports like that!

      ==================================================================

       

      Best Regards,

      Bill