https://community.qlik.com/t5/Talend-Studio/Teradata-has-no-quot-insert-if-not-exists-quot/m-p/2218683#M13797 Hi Kevin<BR />You might get all ids from Teradata first and then do inner join with the source data in tMap.<BR />The rejected rows of tMap will be the rows you want to insert.<BR />Regards,<BR />Pedro Fri, 03 Aug 2012 02:47:26 GMT Anonymous 2012-08-03T02:47:26Z https://community.qlik.com/t5/Talend-Studio/Teradata-has-no-quot-insert-if-not-exists-quot/m-p/2218682#M13796 We are currently switching our database from SQL Server to teradata. We are also converting talend jobs and we have run into an issue. <BR />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. <BR />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. <BR />Has any one else run into this issue? If so what kind of work around(s) have you used? <BR />Thanks, <BR />Kevin Thu, 02 Aug 2012 21:06:19 GMT https://community.qlik.com/t5/Talend-Studio/Teradata-has-no-quot-insert-if-not-exists-quot/m-p/2218682#M13796 Anonymous 2012-08-02T21:06:19Z https://community.qlik.com/t5/Talend-Studio/Teradata-has-no-quot-insert-if-not-exists-quot/m-p/2218683#M13797 Hi Kevin<BR />You might get all ids from Teradata first and then do inner join with the source data in tMap.<BR />The rejected rows of tMap will be the rows you want to insert.<BR />Regards,<BR />Pedro Fri, 03 Aug 2012 02:47:26 GMT https://community.qlik.com/t5/Talend-Studio/Teradata-has-no-quot-insert-if-not-exists-quot/m-p/2218683#M13797 Anonymous 2012-08-03T02:47:26Z