i think..By using joins we can get required records.based on your requirem

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

Question Posted / gowthami

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

Please Help Members By Posting Answers For Below Questions

Explain BYNET.

777

What is a level of granularity of a fact table?

823

Describe primary index in teradata?

764

Explain PDE.

832

What are the steps involved after the disk manager passes the request?

806

how can we analyze the locks ?

1874

Explain the meaning of Amp?

776

What is teradata? What are some primary characteristics of teradata?

751

How would you load a very large file in teradata in general?

793

What do you mean by caching in teradata?

821

Explain the advantages of partitioned primary index in a query?

770

How to load specific no.of records using bteq, or fastload,or multiload

1522

How to run a query in teradata?

795

Difference between star and snowflake schemas?

812

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

947