SLT Initial load not inserting records

[Former Member]

While doing initial loads with SLT, tables are created and defined but records aren't inserted. The error messages were 'Duplicate key errors' and a workaround was to change the Refresh option in Table Settings for each table from 'Drop' to 'No Action'. The tables then get created and loaded after the reloading but no record is inserted.Very strange! Can someone help?

[manish_gupta32]

Please clarify what scenario you are using SLT for. If you are using SLT for Central Finance scenario, then there is a specific reason why this error comes up.
If you are using to load data for non- Central finance scenario, then this error comes because the record you are trying to load already exists in the target.

[Andrey_M]

If you choose the refresh behaviour and at the same time get the "Duplicate key error", it means that the table already exists in target schema and contains the data.