cancel
Showing results for 
Search instead for 
Did you mean: 

Handling "Duplicate Records" using InfoSources with flexible updating

Former Member
0 Kudos
63

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.