I want to write one query
How to get Matched records and unmatched records in table?

Answer Posted / mohan

full outer join can be used to get both unmatched and
matched records..

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of teradata system software?

544


What is the function of parser component in teradata?

614


What is the purpose of using case expression in teradata?

567


What are the multiload utility limitations?

587


What is the basic syntax for teradata select statement?

571






Explain the term 'database' related to relational database management system?

566


What are the available primary index types?

711


How will you solve the problem that occurs during update?

574


What is stored procedure in teradata?

577


What are aggregate tables? How do you design them using teradata?

632


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2339


Describe the between keyword in teradata?

609


What are the different methods ot loading a dimension table? A fact table etc?

568


What is the use of fallback?

550


How is MLOAD Teradata Server restarted after execution?

642