DSXchange

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.

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.

Thanks for the reply.

Job is running on one Node.

We could figure out the issue.
It's because of Nulls coming in one of the Key field. Teradata is unable to compare the Nulls. Replaced Nulls with a dummy character and was able to continuw with the load.