Skip to main content

Hi 

I have tried looking into an article on how can we do data reconciliation on Ataccama, but I only found that can be achieve in Ataccama ONE Web, not on ONE Desktop. How can we achieve the same in ONE Desktop?

My use case is, I want to know the number of rows between two tables from two different databases - Oracle and Snowflake. I tried doing that in ONE Web but it took a lot of time to load.

You can connect to both data sources within the Desktop, bring both tables in from each source that you would like to and run a count on the rows for each table. Once you have both sets of counts, you should be able to do analysis on those counts against each other within the same plan.

​@ThomasPro i have about 30 tables to do the reconciliation and I need to do one by one if I want to do it on ONE Desktop, right? and we need primary key for each table to be able to do the joining before compare for the reconciliation? May you suggest the steps here so that I have a clearer view?

Community Terms of Use & ConditionsCookie settingsAccessibility statement