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

What are the available join types in teradata?

1074

---

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1112

---

How is the teradata different from oracle?

1119

---

Describe primary index in teradata?

1003

---

Different phases of multiload?

1024

---

What is real time and near real time data warehousing?

1120

---

Why does varchar occupy 2 extra bytes?

1201

---

What is bteq utility in teradata?

985

---

Explain and compare pros and cons of snow flake schemas?

1035

---

What happens when a node suffers a downfall?

1140

---

Define views in teradata with general syntax.

1038

---

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

996

---

What is dimensional modeling?

1090

---

What is the difference between global temporary tables and volatile temporary tables?

1187

---

How do you see a ddl for an existing table?

1019

---