Can we find out Column Level Mismatches between 2 Tables in Terdata?

Database
Enthusiast

Can we find out Column Level Mismatches between 2 Tables in Terdata?

I mean to Say when we do a MINUS on TD it returns the Entire Row where the Mismacth is Found. My Question is is there any possibilty where we can find the Column Where Mismatch has Occured and not the Full Row?

2 REPLIES
Teradata Employee

Re: Can we find out Column Level Mismatches between 2 Tables in Terdata?

To do that you should use full outer join way so you can join using key columns and compare the atribute columns one by one

Enthusiast

Re: Can we find out Column Level Mismatches between 2 Tables in Terdata?

Hi AtardecerR0j0,

Yes that way came to my mind too but the challenge here it will be when i am dealing with a table with more number of columns.

Isn't it?

Any other way can it be achived?