Skip to Content
0

Duplicate row Error while loading data into Teradata target database

Jan 23, 2017 at 03:17 PM

868

avatar image
Former Member

Hi Experts,

Could you please let me know how to solve Duplicate row Error In sap bods. Here I am pulling data from sql server and loading to Teradata Target database. while loading data into Teradata I am getting "Duplicate Row Error".

Thanks,Murali

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jan 24, 2017 at 10:36 AM
0

Check your joins in the Query transform?

Check if there is some duplicates flowing in to the target table. Place a Template table before the Target table and check if there are any potential duplicates

You can always find it out by writing a SQL statement and find out duplicates.

A google search gave me the below link.

https://community.teradata.com/t5/Database/Import-Duplicate-row-error/td-p/5553

Regards

Arun Sasi

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 26, 2017 at 06:57 AM
0

Hi Murali,

try to find out if you are getting duplicates from source or target is having a record already and same record is trying to load into target again.

we faced same issue earlier where a record is not present in the target and we have 2 entries in the source for that record. 1st entry loaded and error is when 2nd entry tries to load.

Share
10 |10000 characters needed characters left characters exceeded