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 :)

What is meant by a Clique?

989

---

Why is the case expression used in teradata?

1023

---

What are the frequently used data types in teradata?

1004

---

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

1031

---

any one answer me how they can analyzing the project using data ware housing?

2407

---

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

1000

---

Why does varchar occupy 2 extra bytes?

1105

---

What is the difference between union and union all in teradata?

1048

---

What are the functions involved in shared information architecture?

1016

---

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

957

---

What type of indexing mechanism do we need to use for a typical data warehouse?

1081

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2094

---

Where is teradata rdbms used?

1035

---

How do you determine the number of sessions?

1008

---

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

1057

---