write optimized DSO
Here is my setup:
Flat File -> DataSource -> Write Optimized DSO -> Standard DSO
(the Write Optimized DSO has "Do Not Check Uniqueness of Data" checked)
I have one record in my flat file.
I loaded it all the way to the standard DSO.
Then i modified the value of a field of the record (not a key field) and loaded it again to the write optimized DSO, i have thus two records with the same key and one different value
The problem is that when i then load the data from the Write Optimized DSO to the Standard DSO the DTP somehow condense these two records into one but he doesn't take the latest version, the data in the Standard DSO is thus not longer the same as the data in the flat file.
Thanks for your help