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.
It seems there is only the default solution given by OWB.