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
What is teradata and why it is used?
How will you solve the problem that occurs during update?
What is the opening step in basic teradata query script?
What is dimensional modeling?
Can we collect statistics on table level?
What is the primary index in teradata?
Explain BYNET.
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is oltp?
What is database exceptions in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Why are oltp database designs not generally a good idea for a data warehouse?
Highlight the advantages of PPI(Partition Primary Index).
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Explain PDE.