troubleshoot & Debugging the Pentaho ETL finding out what is the source of error processed is failed, as of now findings Deletion of CustomerNumber is now not working properly that cause encounter duplication error continue tomorrow solving this issue.