We have migrated data from Oracle 9 to Oracle 12.
Is it possible to validate via Talend whether all the data has been moved correctly from Oracle 9 to oracle 12 ?
This data validation can be done table by table or if there is anything that checks the DB with DB would be great.
Are you using talend open studio for data quality? With community edition, it does not support that comparing columns in different database.
Please take a look at this document about:TalendHelpCenter:Redundancy analyses
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.