Skip to Main Content
Forums

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

Comments

David Allan-Oracle
The loading type on a table can insert/update/merge/delete - it's up to you what you do, what happens in a load is dependent on the loading type and the data (if there is no new data, then no new rows will be added). The dimension operator has loading behavior consistent with type 1,2,3 SCDs - in the end it boils down to insert/update/merge also.

Cheers
David
1 person found this helpful
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 21 2013
Added on Jan 24 2013
#11g, #data-warehousing, #oracle, #owb, #warehouse-builder
1 comment
294 views