Mapping between tables or table to dimension OWB 11G

user9213000 Jan 24, 2013 11:07 AM

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

1. Re: Mapping between tables or table to dimension OWB 11G

David Allan-Oracle Jan 24, 2013 4:58 PM (in response to user9213000)

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
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.