Answer Posted / innocent

Hi Parsad,
I hope by running below query you'll get many part of your
answer.

_----------------------------------------------------------_
Select DatabaseName, TableName ,columnName,
Case When IndexType='K' Then 'Primary Key'
When IndexType='S' Then 'Secondary Index'
When IndexType='P' Then 'Primary Index'
When IndexType='Q' Then 'PPIndex'
When IndexType='J' Then 'Join Index'
End as implimented_Index
From DBC.Indices
Where TableName in
( Select distinct TableName
From DBC.Tablesize
Where DatabaseName <>'DBC'
And
CurrentPerm>0
)
Order by 1,2,3



_
Innocent

Why is the case expression used in teradata?

593

---

How to find duplicates in a table?

611

---

Explain the types of join supports by teradata?

588

---

Explain vproc in teradata?

566

---

What are normalization, first normal form, second normal form and third normal form?

628

---

---

Define views in teradata with general syntax.

574

---

Explain parsing engine in teradata?

593

---

What is bteq utility in teradata?

573

---

Name the five phases that come under MultiLoad Utility.

586

---

How will you solve the problem that occurs during update?

586

---

What is teradata? Also, list out some of the primary characteristics of teradata.

579

---

Explain the term 'columns' related to relational database management system?

550

---

Difference between multiload and tpump?

623

---

What is the difference between fastload and multiload?

800

---

What is meant by a Clique?

589

---