Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Teradata Procedure to compare two tables

Status
Not open for further replies.

i150371485

Programmer
Oct 8, 2012
1
US
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

Code:

KEYFIELD is PRIMARY KEY in both Souce and target tables.

Thanks in advance.

Cheers.
 
Just do 2 selects into a temp table that first show fields from B not in A, then fields from A not in B.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top