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

Answer / tdguy

obviously yes and userfriendly utility :).
MLOAD--PHASES--5;MAXIMUM TABLES--5;DML STATEMENTS SUPPORTED-
-INSERT,DELETE,UPDATE,UPSERT;DDL STATEMENTS SUPPORTED--
DROP;ERROR TABLES TO BE DEFINED--YES;WORK TABLES TO BE
DEFINED--YES;

What is the opening step in basic teradata query script?

0 Answers  

---

what is the difference between primary index and secondary index?.

2 Answers   IBM,

---

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. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com

0 Answers  

---

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  

---

What is logical data model?

0 Answers  

---

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

0 Answers  

---

What is meant by a Highest Cost Plan?

0 Answers  

---

what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 Answers  

---

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

0 Answers  

---

What are the advantages of teradata?

0 Answers  

---

How do you see a ddl for an existing table?

0 Answers  

---

What is a pseudo key? What is its use???

2 Answers   Mphasis,

---