Skip to Content

Duplicate row Error while loading data into Teradata target database

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 24, 2017 at 10:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 26, 2017 at 06:57 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded