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!

Mapping between tables or table to dimension OWB 11G

user9213000Jan 24 2013 — edited Jan 24 2013

Hi,

I want to know the difference between mapping to a dimension and mapping to a table.

My company already has mappings created...

They map from a table to a dimension. Not as a SCD.

When I run the mapping it only updates the target dimension table, no new rows are added.

I see when I create a mapping between to tables, I can choose loading type.

I was wonder why you would load to a dimension if only updates rows. How can I load to a dimension and have my inserts running as well.

Thank you for any help offered

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 21 2013

Added on Jan 24 2013

#11g, #data-warehousing, #oracle, #owb, #warehouse-builder

1 comment

295 views