on 05-04-2007 4:29 PM
Hi all,
I know it is possible to handle <b>Duplicate Records</b> using <b>InfoSources with direct updating</b>. However, I need to use an <b>InfoSource with flexible updating</b> for loading master data. However, in my case, I can't see the option "Ignore the Double Data Record" in my infoPackage.
Is there a simple way to handle double data records when working with InfoSources with flexible updating for master data loading?
Att.
Claudiomar
Claudiomar Cunha,
Delete duplicate records in Start Routine using "DELETE ADJACENT DEPLICATES". If you are in 2004s, you have one check box in DTP. It will work as similar to DELETE ADJACENT DUPLICATES.
One more thing, <u>don't use DELETE ADJACENT DUPLICATES for Time Dependant data</u>.
Regards,
Nagesh Ganisetti.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
the only way to handle this situation is
- load the data to PSA and subsequently update in the target. This is to force sequential processing and avoid duplicate records across data packages.
- implement a start routine removing duplicate records from your datapak with
SORT DATA_PACKAGE BY KEY1 KEY2.
DELETE ADJACENT DUPLICATES FROM DATA_PACKAGE COMPARING KEY1 KEY2
hope this helps,
Olivier.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.