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
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is inner join and outer join?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
what are the day to day activities of teradata DBA ?
What do you mean by parsing?
What is real time and near real time data warehousing?
Explain the parallel data extension in teradata?
Highlight the limitations of TPUMP Utility.
What is the difference between teradata and oracle?
What are differences between teradata and ansi session modes in teradata?
Why teradata is used?
Explain the term 'primary key' related to relational database management system?
What are the components provided on node?
Describe primary index in teradata?