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 |
what are the day to day activities of teradata DBA ?
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
What are the joins in teradata and how many types of joins are there in teradata?
How do you do backup and recovery in teradata?
What's the syntax of sub string?
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
In your project what type of issues and errors you facing in Teradata
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Explain BYNET.
How to Extract data from multiple legacy systems?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?