Skip to Content
author's profile photo Former Member
Former Member

Delta between ODS with Data field as key field

Hello,

I have a problem with a data load between two ODS. Below is the scenario

ODS 1 has delivery data with delivery Doc and Delivery Item as key field and Plant,Material, Delivery Qty, etc.. as Data filed

ODS 2 need to create as a aggregare at the plant, material level. So for ODS 2, Key Field is Plant, Material and the Data filed is Delivery Qty (additive), etc...

When I load the Full load it works correctly, But when I bring the data as a delta it is updating the delivery Qty incorrectly and some of the data fileds are comming as blank also eventhough the source ODS (ODS1) has data.

Can we use data filed from ODS1 as a Key filed for ODS2 ?

Is that causing the

Regards,

Biju

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 30, 2008 at 06:54 PM

    Hi,

    Looks like someone deleted/ added/ updated some entries in the change log table of ODS1.

    Did you check the "Change log" of ODS1 and compare with the delta request of ODS2?

    Isn't change log of ODS1 showing the entries you got as part of delta in ODS2?

    Another recommendation would be to compare the "Change log" of ODS1 with the "Active" table of ODS1 and see if they are showing the same value of the key figures.

    - Ashish

    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.