Hi,
We are extracting data from a Flat file and loading to Table A. In the After Sql, we wrote a Merge query to Upsert data into Table B (which is a archive of Table A). Insert statement for Table A is running fine where as the Merge query for Table B is failing with error.."RDBMS code 2802: Duplicate row error ".
Job Design:
Flat File --> Remove Duplicate --> Teradata
Any Suggestions on above please.
Teradata Connector Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Don't send duplicate rows. This might be because the same key has been processed in different partitions. The Remove Duplicates stage only removes duplicates per partition; therefore your data should be partitioned using a key-based algorithm on the Remove Duplicates key ahead of that stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.