Skip to Content
0
Former Member
Feb 26, 2009 at 09:47 AM

ODS Error: "Extra Records added while updating"

20 Views

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