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
- 11055 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohan
full outer join can be used to get both unmatched and
matched records..
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / vimal
We can use minus query and intersect query
unmatched: records in a but not in b
select *
from a
minus
select *
from b ;
matched: recrods in a and in b
select *
from a
intersect
select *
from b ;
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / 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 |
Answer / 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 |
Explain BYNET.
How many sessions of MAX is PE capable of handling at a particular time?
What is partitioned primary index (ppi)?
Why do you get spool space errors? How do trouble-shoot them?
how can we analyze the locks ?
IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 Answers Cap Gemini, IBM, Infosys,
What are the different table types that are supported by teradata?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
What are the various indexes in teradata? How to use them? Why are they preferred?
1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?
Increasing no of amps will increase performance. Is this true?
What does Amp contain and what are all the operations that it performs?
Teradata 
