Comparing values from two tables

Badge +1
  • Space Explorer
  • 1 reply


Situation: I wrote a(n) SQL catalog item joining multiple tables and in Ataccama I'm using rules to compare the values if they are the same. LONG = LONG, check if the nr_loan = the same a.nr_loan, etc.

My question is if there's an easier way to see if two tables are identical. I'm doing this to check the integrity.

I couldn't find anything relatable asked in the community.




Best answer by Cansu 22 May 2023, 15:35

View original

2 replies

Userlevel 4
Badge +6

Hi @JTH, thank you for posting! Currently, the only way to compare two tables is to join them in a VCI and apply cross-attribute checks or with an SQL CI as you’ve described as your current practice. 

Badge +1

Thank you!