i150371485
Programmer
Hello Experts,
I am newbie to teradata. I have a requirement to compare the two tables in teradata. I have used minus query to find out te differences. i used to do A MINUS B UNION B MINUS A . But it if there are any differences it will dispaly whole reocrds. Is there a way we can get mismatches report as below
KEYFIELD is PRIMARY KEY in both Souce and target tables.
Thanks in advance.
Cheers.
I am newbie to teradata. I have a requirement to compare the two tables in teradata. I have used minus query to find out te differences. i used to do A MINUS B UNION B MINUS A . But it if there are any differences it will dispaly whole reocrds. Is there a way we can get mismatches report as below
Code:
KEYFIELD is PRIMARY KEY in both Souce and target tables.
Thanks in advance.
Cheers.