My scenario is :
Source : DSO
Target : DSO
In the transformation from source to target, in the END routine I have implemented the logic to look up the data in some mapping tables. The End routing has to check for corresponding entry in look up table if it is available then it has to cretae one more record for that particular source record. The key for old and new reocrd is different, but still while insering the record into target DSO I am getting "Duplicate Record Error"
Please help me if you have faced same issue earlier and managed to resolve it.
Hari Prasad Balija.