If the table does not have duplicates then which utility you
can suggest to load the data ?
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
What is TPD?
What is collect statistics?
Explain some differences between mpp and smp?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is meant by a Channel Driver?
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 ?
What are the components provided on node?
Explain Teradata performance tuning and optimization?
What can be achieved by using the teradata rdbms?
What do you mean by fastexport in teradata?
how do you manage the production space. what are the proactive methods you can take ?
What are the functions of a Parser?
What is the meaning of Caching in Teradata?
Why do you get spool space errors? How do trouble-shoot them?