Wednesday, March 22, 2017

Taledn Open Studio - How to use tMap to output all records in one table but not exist in the other table?

This is the example about how to use tMap component in Talend to extract all records in one table but not in the other table.



DB1 has 12 records, there is one record whose key has existed in db2 table. So I would like to have only new records not in db2 table should output to db_output.

Let's look at the tMap setup. DB1 is main input (row1), db2 is the lookup (row2). In the lookup, choose Inner job. In the output choose Catch lookup inner join reject = true.