delete records with subquery

Anonymous — Tue, 21 Jul 2015 14:41:09 GMT

I have two tables in two databases (MYSQL & SQL*Server)

I would like to implement, with talend, the following query:

delete from T1 where T1.key in (select t2.key from T2 where T1.key=T2.key and T1.date<T2.date)

is it possible ?

If yes how?

Thanks

Didier

Re: delete records with subquery

Anonymous — Mon, 03 Aug 2015 15:22:52 GMT

Using a tMap to a join between T1 and T2 to get the t2.key, if there exist multiple keys, denomalize all the keys to one line after tMap, write the delete query in a tXXXRow component. eg:
tMysqlInput--main--tMap--main--tDenormalize--main(row2)--tFlowToIterate--iterate--tMssqlRow
|
lookup
|
tMssqlInput

on tMssqlRow, you can write the query as below:

"delete from T1 where T1.key in "+(String)globalMap.get("row2.columnName")

topic Re: delete records with subquery in Talend Studio

delete records with subquery

Re: delete records with subquery