Skip to Content

DTP delta incorrect sequence

Hi all,

I have a DSO which is loaded by 2 flatfiles. The DSO is loaded with the first flatfile and activated. The second flatfile is loaded and active records are updated with additional information.

The data is loaded into the next DSO with the delta. The problem is that changed records from the first DSO have 3 records in the change log. These records are not loaded correctly in the second DSO.

As an example: In the first flatfile I load employee number with the costcenter and the FTE number. In the second file, I update the employee nr with the contract type. When loading to the second DSO, some records are correct with all 3 fields filled, but some only have employee number with the costcenter.

The change log is correct, but it looks like the delta load from the change log is not in the correct sequence. I need a delta load, because I am loading every month.

Does anybody has any idea how to solve this.

Thanks in advance

Regards,

Paul

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 01:03 PM

    Hi,

    do you have different transformations for those loads? If not, the error might be that you are normally updating all the fields of your dso from both sources but the delivered fields will then overwrite each other depending on the key.

    Let us know.

    regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.