Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table duplication for loading SCD 2 Dimensions

435128Jan 11 2012 — edited Nov 7 2012
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.

Comments

435128
It seems there is only the default solution given by OWB.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 5 2012
Added on Jan 11 2012
1 comment
109 views