Multiple Changes in Monthly FIle From Source.

• raja.roopa

  Grasshopper

  Points: 13

  More actions

  February 10, 2012 at 8:33 pm

  #256670

  Hi

  Can you please provide me stored proc logic to capture the changes from source file while loading into datawarehouse.

  eg:

  Source (Monthly input in Jan)

  Empid Emp Name Date

  1 ABC Jan 1st

  1 DEF Jan 10th

  Target Output

  Empid Emp Name Start Date End Date

  1 ABC Jan 1st Jan 9th

  1 DEF Jan 10th Null

  Source (Monthly input in Feb) , will also have history

  Empid Emp Name Date

  1 ABC Jan 1st

  1 DEF Jan 10th

  1 GHI Feb 1st

  Target Output

  Empid Emp Name Start Date End Date

  1 ABC Jan 1st Jan 9th

  1 DEF Jan 10th Jan31st

  1 GHI Feb 1st

  Please reply with the approach..Thank you

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  February 13, 2012 at 12:37 am

  #1446104

  You could use the slowly changing dimension wizard in SSIS, but it is a bit slow. Here's a list of alternatives:

  Alternatives to SSIS SCD Wizard Component

  [/url]

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP