5

Need Suggestion : Please share your ideas

view full story
linux-howto

http://www.unix.com – Hi Friends, I have a requirement where i need to compare the 2 tables ( Let assume SOURCE table and TARGET Table )in teradata . before this requirement we used to do a MINUS query and did the work. But now we came to situation where we need to get the expected output as below : Code: No of Mismatches :   Mismatches Report :   KEYFILED(UNIQUE Filed) | SORCE FIELD(ORIGINAL VALUE)| TARGET FIELD(CHANGED VALUE) I did the following to get the output in unix . Quote: 1) Dumped 2 tables data in to files 2) Delimit the columns by "|" 3) sor (HowTos)