This discussion is archived
2 Replies Latest reply: Jan 24, 2013 1:08 AM by user5716448 RSS

Best way to load old historical records into sc2 type 2 dimesnion

user5716448 Explorer
Currently Being Moderated

We have scd type 2 diemsnion and have history dating form early 2012 in there but wish to add extra older historical episodes of recoprds for 2011 into it.

What is the best way to do this?


Considering some pl/sql but 5 levels in the dimesnion.

Can't reload as need existing records due to integirty with facts.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points