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