Answer Posted / yuvaevergreen

Three strategies followed by optimizer are:
1.Duplication of rows of one table to every amp
--> This one is opted by optimizer when the non-PI column
is on a small table.
2.Redistribution of the non PI rows of the table to the amp
containing the matching PI row amp.
--> This one is opted when the tables are large. The non PI
column is in one table is redistributed to the amp
containing the matching PI.
3.Redistribute both the rows of the table by hash values.
--> This is chosen when the join is on a column that is not
the PI in either table. This will require the most spool
space.

Explain the term 'foreign key' related to relational database management system?

1040

---

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1018

---

What do you mean by parsing?

1108

---

During the Display time, how is the sequence generated by Teradata?

1050

---

What is the meaning of Caching in Teradata?

1135

---

How to identify ppi columns?

1175

---

List out teradata data types?

1005

---

What is bteq utility in teradata?

963

---

What are the functions of a teradata dba?

1072

---

What are the scenarios in which full table scans occurs?

1008

---

Describe primary index in teradata?

999

---

Why managing the data is important?

1013

---

Define views in teradata with syntax.

1076

---

What is a level of granularity of a fact table?

1150

---

Comment whether bottleneck is an error or not.

1152

---