Answer Posted / satish

When table is having NUSI, the sub table created by it will
be populated only by Hashing (not like Hash Re distribution
for USI), here redistribution of the records will not be
done,which will take more time generally,

As Fastload and Multiload are intended to Load the data at
fast they have taken out the USI, support so that the target
tables will be loaded very faster,

if we need we can create the SI after loading

---
If you have better ANS please Share with us

What are the functions of a Parser?

1027

---

How is MLOAD Teradata Server restarted after execution?

1166

---

Comment whether bottleneck is an error or not.

1073

---

What do you mean by tpt in teradata?

959

---

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2796

---

What is meant by Teradata Gateway?

1002

---

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 ?

2418

---

Is multi insert ansi standard?

2144

---

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1152

---

What can be achieved by using the teradata rdbms?

980

---

What is meant by a dispatcher?

955

---

Write a program to show the parser component used in teradata?

913

---

What is a level of granularity of a fact table?

1071

---

Explain teradata utilities. What is multiload, fast load, tpump?

948

---

How to Extract data from multiple legacy systems?

1040

---