Answer Posted / adi

Fload will allow multiset table. But there is no advantage
of loading multiset table using fload, becuase fload does
not insert duplicate rows. If we try to load multiset table
using fload with duplicate rows, they fload inserts
distinct rows into the target table and the duplicate row
count displayed under second error table.

if collect stats but it show low confidence why?

1745

---

What are the steps involved in the process flow of the sql statement through channel attached system?

1155

---

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1154

---

What is the purpose of joins in teradata?

1258

---

What is the primary index in teradata?

1277

---

What are the functions involved in shared information architecture?

1117

---

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

1032

---

List out teradata data types?

1060

---

What are teradata utilities?

1151

---

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

1156

---

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

2450

---

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

1021

---

What are the various indexes in teradata? How to use them? Why are they preferred?

1107

---

Name the five phases that come under MultiLoad Utility.

1024

---

How can you track login parameters of users in teradata?

1223

---