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
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.