DTP Filtering New Records with Same Key
I have having some difficulty with DTP's in BI NW2004s. I seem not to understand how they are supposed to work.
I have migrated 2LIS_12_VCSCL to the 7.x process and created a DTP to load my DSO. This all seems to work fine.
My dilema comes when I want to reload the DSO without pulling new data from R/3. I deleted all the data in the DSO, then execute the DTP and it loads all the previously data packages. This, on the surface looks fine, but the results are incorrect.
After troubleshooting it, what I have found is that for records that share the same semantic key, it is filtering the records and only updating the DSO with the OLDEST record.
This is resulting in bad records in the DSO and subsequent data providers. Can anyone point me in the right direction on this?