Answer Posted / sat!sh

YES,

We can Load SET, MULTISET tables using Mload, But here when
loading into MULTISET table using MLOAD duplicate rows will
not be rejected, we have to take care of them before
loading.

But incase of Fload when we are loading into MULTISET
duplicate rows are automatically rejected, FLOAD will not
load duplicate rows weather table is SET or MULTISET

----
Hi Friends Got a Best ANS share with us :)

Explain vproc in teradata?

999

---

What are the components used in smp and massively parallel processing (mpp) machines?

1057

---

What is database exceptions in teradata?

952

---

How to view every column and the columns contained in indexes in teradata?

1056

---

What is meant by a Parsing Engine?

1188

---

What are teradata utilities?

1109

---

What interface is used to connect to windows based applications?

1113

---

What do high confidence, low confidence and no confidence mean in explain plan?

1048

---

How many types of joins are there in teradata?

976

---

How can bottlenecks be identified?

1015

---

What is smp and mpp platforms?

971

---

Which is faster fastload or multiload?

1112

---

Describe primary index in teradata?

1000

---

What is a clique?

1093

---

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1169

---