Data Validation of two similar tables in different oracle version

Highlighted
Seven Stars

Data Validation of two similar tables in different oracle version

Guys,

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.

 

Thanks

 

Moderator

Re: Data Validation of two similar tables in different oracle version

Hi,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read