3339624 - Duplicates during extraction even though DISTINCT is used in sql block

As we have just 40 records, it looks like issue with customer's Primary key configuration. Check whether they have done NON NULL as the primary key configuration.

And to avoid actual data duplication issue in future kindly ask customers to

• Install SAP NOTE 2246160
• And set below parameters as "Extra Connection Arguments"
  RFCReadTableOptions=USE_ET_DATA_4_RETURN,GET_SORTED;Pagesize=20000 

KBA , BPI-SIG-PI-DTT , Data Transformation Templates , Problem