Interested to Buy Any Domain ? << Click Here >> for more details...
If the table does not have duplicates then which utility you
can suggest to load the data ?
- 3 Answers
- 6609 Views
- I also Faced
- E-Mail Answers
Answer Posted / rkraju
Hi,
>>If the table doesn't have any
duplicates(triggers,sp,ji,hi,nusi,usi) we go for fastload.
>>if the table data <1mill we go for bteq
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain the term 'row' related to relational database management system?
Explain teradata utilities. What is multiload, fast load, tpump?
What is meant by a Virtual Disk?
How does hashing happens in teradata?
What are aggregate tables? How do you design them using teradata?
In general, how do you optimze any sql in teradata?
What is meant by a Channel Driver?
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?
During the Display time, how is the sequence generated by Teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
What is spool space? Why do you get spool space errors?
Describe the set operators in teradata.
How many sessions of MAX is PE capable of handling at a particular time?
Difference between multiload and tpump?
Highlight all the modes that are present under Confidence Level.
