ERROR WHILE LOADING DATA INTO DATABASE

[sam473]

Hi,

I am getting following error when execute ,someone can help me how to sort these type of errors.

INPUT DATAJOB DESIGNSCHEMASQL_ERRORSQL ERROR

[manodwhb]

@sam473 , do you have duplicate records based on company, product, and salt ?

[sam473]

in this scenarion Combination of company product salt is unique.

 but I tried other by adding surrogate key s.no using tmap even though same error came

[manodwhb]

Then you have duplicates.

[sam473]

what is the solution if my data is having duplicates and i want to store the data in database without error

[manodwhb]

@sam473 , first you need to eliminate duplicates and load the data into the table.