Teradata Connector Error

balu536 · Post by **balu536** » Wed Dec 18, 2013 1:49 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 18, 2013 9:51 pm

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.

balu536 · Post by **balu536** » Thu Dec 19, 2013 10:48 am

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.