Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srinu
The Table is having too many Duplicate rows, The Skew table
will hadle the duplicate rows up to limitations,Once its
cross the no of Rows it will effect on Performence.The Dba
people will the SKEW tables.
I think this Answer helps u
| Is This Answer Correct ? | 10 Yes | 29 No |
Post New Answer View All Answers
Explain the parallel data extension in teradata?
How do you see a ddl for an existing table?
if collect stats but it show low confidence why?
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 ?
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?
How does hashing happens in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is partitioned primary index (ppi)?
What are normalization, first normal form, second normal form and third normal form?
What is the syntax for case when statement?
Highlight all the modes that are present under Confidence Level.
What are the different design perspectives used in teradata?
What are the available join types in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain BYNET.
