Teradata has no "insert if not exists"

Teradata has no "insert if not exists"

We are currently switching our database from SQL Server to teradata. We are also converting talend jobs and we have run into an issue.
On the SQL Server output components there is an "insert if not exist" option. The problem is there is no equivalent option for the standard teradata output component.
We need this functionality as without it our jobs fail when a duplicate is inserted because of constraints on the tables. Also update is not an option.
Has any one else run into this issue? If so what kind of work around(s) have you used?
Thanks,
Kevin
One Star

Re: Teradata has no "insert if not exists"

Hi Kevin
You might get all ids from Teradata first and then do inner join with the source data in tMap.
The rejected rows of tMap will be the rows you want to insert.
Regards,
Pedro