hope you can give my some hints how to handle the following with Talend:
How can I compare 2 columns in 2 different databases with each other?
e.g. there is database1, table1, column1 and database2, table2, column2.
Is there an easy way to compare these values in Talend?
Please note that I do not have a database link, so I cannot compare the values within a single SQL statement.
Therefore I have to connect to two databases.
I thought of doing this comparison with tMap component - although tMap main purpose is for data integration.
Making the main connection to database 1 and the lookup connection to database 2.
Is this the right way? Or is there a better one?
Please note also that I have simplified my request. In reality I will have to do more complex comparison.
Something like comarisons with regular expressions, substrings, logical AND, OR, IF.. THEN... and so on.
thanks for your help