Interested to Buy Any Domain ? << Click Here >> for more details...
I want to write one query
How to get Matched records and unmatched records in table?
- 4 Answers
- 11034 Views
- TCS, I also Faced
- E-Mail Answers
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
List out all forms of LOCKS that are available in Teradata.
What are aggregate tables? How do you design them using teradata?
Can we collect statistics on table level?
Is multi insert ansi standard?
Can we collect statistics on multiple columns?
What is multi insert?
What is the difference between global temporary tables and volatile temporary tables?
What is the function of parser component in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Why managing the data is important?
Explain and compare pros and cons of snow flake schemas?
Why do you get spool space errors? How do trouble-shoot them?
If a Node is busy what are the steps you can take to avoid ?
Explain the teradata primary index mechanics in detail with a diagram.
