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 CansuView original
@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.