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?
"delete from T1 where T1.key in "+(String)globalMap.get("row2.columnName")
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema