Hi Team,
I want to Compare Two Tables from Two different Databases.
What i did:
I created two model ( Model A: MYSQL ) , (Model B: SQL Server)
I have Created same table ( Department) in both the Databases respectively but i have Add Column 'SAL' extra in Model A.
Now i have followed the Steps to compare Model A to Model B as provided in the CATALOG Documentation:Comparing two different objects
But here i get not useful information
Can you provide a correct way to compare two hetrogenous Databases in Talend Data Catalog.
PFA Snips for better understanding.
Model A:(MYSQL)
Model B: SQL Server:
Comparing Models:
Output:
Choosing Highlight Differences From Row1:
Choosing Highlight Differences From Row2:
Choosing Highlight Differences From Row3: