1 Reply Latest reply: Nov 7, 2012 6:55 AM by 435128 RSS

    Table duplication for loading SCD 2 Dimensions


      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?