Answer Posted / tdguy
highly non unique PI values, more number of null values can
create a hot amp condition., which means one or more amps
will be holding more rows than other amps. Distribution
occurs unevenly. This can cause out of spool space error.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain vproc in teradata?
What is teradata and why it is used?
What is a node in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the uses of client software involved in teradata?
What are the design features involved in teradata?
What is the difference between fastload and multiload? Which one is faster?
How to Extract data from multiple legacy systems?
Is multi insert ansi standard?
What are the various indexes in teradata?
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 ?
How many codd's rules are satisfied by teradata database?
How you will check the version of teradata?
What do you mean by fastexport in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?