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;

When tpump is used instead of multiload?

0 Answers  

---

What are the joins in teradata and how many types of joins are there in teradata?

0 Answers  

---

What is the purpose of upsert command?

0 Answers  

---

What are different table types used in teradata?

0 Answers  

---

What are the types of tables in Teradata

22 Answers   Cap Gemini, Cognizant, Infosys,

---

How do you load Multiple files to a table by using fastload scripts?

1 Answers   Satyam,

---

Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q

45 Answers  

---

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?

6 Answers   Bank Of America, Wipro,

---

Explain amp in teradata?

0 Answers  

---

Increasing no of amps will increase performance. Is this true?

5 Answers   Infosys,

---

Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance

4 Answers   IBM,

---

what is amp plz explanation

5 Answers   IBM,

---