ODS Error: "Extra Records added while updating"

[Former Member]

Experts,

I am loading PO_ITM records from an ODS(datawarehouse layer) to an ODS (Consolidated Layer).

The scenario is I have individual ODS at datawarehouse layer which get the PO, ITM and SCL data respectively and then I upload from these 3 ODS into the consolidated ODS.

The key fields in the cons ODS is 0DOC_NUM, 0DOC_ITEM, 0FISCVARNT, 0CALDAY mapped to 0DOC_DATE (From PO_ITM ODS) and 0PROCESSKEY.

Issue:

When I load from datawarehouse PO_ITM ODS to this Cons ODS, there is an extra record for a particular record. SAY I have PO 705000006, the no of this record in PO_ITM ODS is 3. When I load this into Cons ODS, I get 4 records.

See the data below:

PO_ITM ODS:

PROCESSKEY DOC_NUM DOC_ITEM FISCVARNT DOC_DATE ENTRY_DATE

1 705000006 10 N1 11/05/2007 11/05/2007

1 705000006 20 N1 11/05/2007 11/05/2007

2 705000006 10 N1 11/05/2007 08/28/2008

In Cons_ODS:

DOC_NUM DOC_ITEM FISCVARNT CALDAY PROCESSKEY HDRPROCESS RECORDMODE

0705000006 000010 N1 11/05/2007 001

0705000006 000010 N1 11/05/2007 002

0705000006 000010 N1 08/28/2008 002

0705000006 000020 N1 11/05/2007 001

Any ideas?

Thanks,

Jain

[Former Member · Accepted solution]

It is because in your second ods (cons) there is a field called CALDAY and this is updated with first ODS's ENTRY_DATE.

Sarhan.

[Former Member · Accepted solution]

To reconfirm your saying, I checked the transformation again.

0CALDAY is mapped to 0DOC_DATE.

0ENTRY_DATE is mapped to 0ENTRY_DATE.

Hence though it seems to pick up the value of the 0ENTRY_DATE while updating to cons ODS, the mapping says otherwise.

What do you think can be the cause?

Jain

[Former Member · Accepted solution]

This might be because of the active version of the transformations, just activate the transformations.

Sarhan.

[Former Member · Accepted solution]

Thanks Sarhan.

I stand corrected. There is a rule group called 0ENTRY_DATE, which is also mapped to the 0CALDAY.

My question is: Does it add a new record to every a specific PO and its respective Item OR only when the DOC_DATE differs from the ENTRY_DATE for a particular PO and its Item.

Jain

[Former Member · Accepted solution]

If the key fields combination will be new then ODS will add records otherwise it will be updated.

Sarhan.