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.

What is the purpose of indexes?

1010

---

Is multi insert ansi standard?

2145

---

What is real time and near real time data warehousing?

1063

---

What is stored procedure in teradata?

956

---

Explain teradata utilities?

981

---

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

981

---

Highlight the points of differences between the database and user in Teradata.

1040

---

When tpump is used instead of multiload?

1040

---

How do you verify a complicated sql?

1012

---

Describe primary index in teradata?

957

---

Highlight a few of the advantages that ETL tools have over Teradata.

1031

---

What is the difference between teradata and oracle?

955

---

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

973

---

If a Node is busy what are the steps you can take to avoid ?

2347

---

What do you mean by ttu in teradata?

973

---