1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

Can we load a Multi set table using MLOAD?

Question Posted / ramya85

Answers were Sorted based on User's Feedback



Can we load a Multi set table using MLOAD?..

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

Is This Answer Correct ?    35 Yes 1 No

Can we load a Multi set table using MLOAD?..

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;

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Teradata Interview Questions

What's the difference between timestamp (0) and timestamp (6)?

0 Answers  

in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?

2 Answers   HCL,

How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????

3 Answers   Mphasis,

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

0 Answers  

What are the types of tables in Teradata

22 Answers   Cap Gemini, Cognizant, Infosys,




How do you define Teradata?

0 Answers  

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

3 Answers   IBM,

How can you track login parameters of users in teradata?

0 Answers  

How do you see a ddl for an existing table?

0 Answers  

Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE

2 Answers   IBM,

Explain vproc in teradata?

0 Answers  

Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,

For more Teradata Interview Questions Click Here
Categories