1 Reply Latest reply on Jan 24, 2013 4:58 PM by David Allan-Oracle

    Mapping between tables or table to dimension OWB 11G


      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