Hi All,
I am extracting records from SAP system and after my Table comparison transform (SCD1 implementation) i am loading details into target table.
I have Bulk load enabled for target table with Mode as Append and rows per commit as 3000.
It is resulting me warnings "cannot insert duplicate keys". When i disabled the bulk load option no warning were reported and job completed successfully.
Confused on what exactly might have happened, can some one please explain me what could have happened.
Thanks
SR