This discussion is archived
1 Reply Latest reply: Nov 7, 2012 4:55 AM by 435128 RSS

Table duplication for loading SCD 2 Dimensions

435128 Newbie
Currently Being Moderated
Hi,

I'd like to load a dimension table with SCD2 logic. I created the target table, dimension, I made the mapping so that source staging tables are mapped into DIMENSION object. It all works. But when I checked what's behind... a copy of all source staging tables were created in the source schema with OWB$... name and all data were generated from these sources instead. It is a possibility not to use tables (perhaps views) by the automated mapping mechanism? Is there a workaround so someone can achieve the above scope without duplicating all source staging objects?
Cheers.

Legend

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