This discussion is archived
1 Reply Latest reply: Jan 24, 2013 8:58 AM by David Allan RSS

Mapping between tables or table to dimension OWB 11G

user9213000 Newbie
Currently Being Moderated

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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points