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.