1 )Primary index a)UPI b)NUPI 2) Secondary index a)USI b)NUSI 3)Parti

How many types of index are present in teradata?

Question Posted / krishna

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

In Teradata, how do we Generate Sequence?

983

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?

1134

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

935

Highlight the advantages of PPI(Partition Primary Index).

1006

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2101

What are types of partition primary index (ppi) in teradata?

1001

How will you solve the problem that occurs during update?

987

List the logical and conditional operators that are used with teradata along with their meanings?

940

What are tpump utility limitations?

1063

Syntax for case when statement?

1010

How to Extract data from multiple legacy systems?

1043

Mention a few of the ETL tools that come under Teradata.

1014

How does hashing happens in teradata?

1019

How you will check the version of teradata?

1079

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4322