How many types of index are present in teradata?
Answer / krishna
1 )Primary index
a)UPI
b)NUPI
2) Secondary index
a)USI
b)NUSI
3)Partition primary index
a)Range Partition
b)Case partition
4) Hash index
5)Jion index
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain and compare pros and cons of snow flake schemas?
Explain the meaning of Amp?
In Teradata, what is the significance of UPSERT command?
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
Highlight the limitations of TPUMP Utility.
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
what are the file sizes in your project?
Difference between inner join and outer join?
What are the different functions performed in development phase?
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A