Table duplication for loading SCD 2 Dimensions
435128Jan 11 2012 — edited Nov 7 2012Hi,
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.