2 Replies Latest reply: Jan 24, 2013 3:08 AM by user5716448 RSS

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


      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.