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

Answer Posted / gowthami

i think..By using joins we can get required records.based on
your requirements we should choose left outer join or right
outer join

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name the five phases that come under MultiLoad Utility.

762


Where is teradata rdbms used?

859


What is upsert statement in teradata?

820


What is smp and mpp platforms?

717


What interface is used to connect to windows based applications?

803


Explain teradata architecture in detail with a diagram.

846


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

831


Differentiate primary key and partition key?

751


Difference between multiload and tpump?

837


What do you mean by teradata intelliflex?

832


Explain how spool space is used.

838


While creating table my dba has fallback or no fallback in his ddl. What is that?

890


What are tpump utility limitations?

847


What happens in a conflict? How do you handle that?

829


What is the use of virtual processor connectivity in teradata?

779