Answer Posted / rashid equbal

Join Index is nothing but pre-joning 2 or more tables or
views which are commonly joined in order to reduce the
joining overhead.
So teradata usdes the join index instead of resolving the
joins in the participating base tables.
They increase the efficiency and performance of join
queries.
They can have different primary indexes than the base tables
and also are automatically updated as and when the base rows
are updated. they can have repeating values.

There are 3 types of join indexes:
1) Single table join index - here the rows are distributed
based on the foreign key hash value of the base table.
2) Multi table join index - joining two tables.
3) Aggregate join index - performing the aggregates but
only sum and count.

What is meant by a dispatcher?

1021

---

What are the different softwares used with their functions in teradata?

1015

---

What do you mean by fastexport in teradata?

1003

---

What are the joins in teradata?

1015

---

How to load specific no.of records using bteq, or fastload,or multiload

1747

---

What are the enhanced features in teradata v2r5 and v2r6?

1138

---

what are the uses of fact table and dimension table in banking project?

4556

---

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

1109

---

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1154

---

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

3501

---

What does Amp contain and what are all the operations that it performs?

1006

---

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2481

---

What is a three-tier data warehouse?

1116

---

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

954

---

how do you manage the production space. what are the proactive methods you can take ?

1947

---