Write optimised DSO - it seems to hold data by request which means if data with the same key is loaded then the system will hold duplicate keys. On the basis my understanding is correct and i know you can tick a box to not allow duplicate keys - i am assuming this will mean the loads just fail? Is that right?
Is there a way to set the loads to overwrite data with same keys (not technical ones) in the write optimised DSO?
What is the difference between a write optimised DSO and a standard one which you load to the active table, switch off SIDs?