Mapping between tables or table to dimension OWB 11G
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