Answer Posted / priya

Fload It self will not support Secondarys Indexs concept
becuase Fload stands for Fast load so.. it will not proceed
futhur in case the table is defined with Secondary indexes
we need to drop the Secondary index in case if we need to
proceed furthur.

So where is the concpets USI and Non-Unique secondaey
indexes in Fload.

Regards,
Priya K

What is the use of teradata system software?

1032

---

What do you mean by teradata sql assistant?

1055

---

Discuss the advantages of using partitioned primary index in a query?

949

---

what is object level locking ? where do appear this type of locking ?

3490

---

Explain the types of join supports by teradata?

989

---

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?

1107

---

What are default access rights in teradata?

1115

---

Where is teradata rdbms used?

1092

---

What are the various indexes in teradata? How to use them? Why are they preferred?

1061

---

What is a dimension table?

1061

---

What is the opening step in basic teradata query script?

1037

---

What do you mean by teradata intelliflex?

1088

---

if collect stats but it show low confidence why?

1683

---

Explain some differences between mpp and smp?

1096

---

Write a program to show the parser component used in teradata?

972

---