Slowly Changing Dimension type2

• arasupraveenkumarreddy

  Valued Member

  Points: 61

  More actions

  March 8, 2011 at 8:14 pm

  #233085

  I have an Excel sheet which needs to be loaded into the dimension table.This is a SCD type 2 task.I have a few columns which need to be addressed as historical attributes .Can I know the complete procedure to do this ,since I am facing a few issues while configuring the SCD component.

  Thanks in advance.

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  March 9, 2011 at 12:02 am

  #1296327

  More information on the SCD:

  http://msdn.microsoft.com/en-us/library/ms141715.aspx

  http://msdn.microsoft.com/en-us/library/ms141662.aspx

  What are the issues that you are facing?

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