Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

2 Answers   IBM,

Which is more efficient group by or distinct to find duplicates?

0 Answers  

Explain PDE.

0 Answers  

what is amp plz explanation

5 Answers   IBM,

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

0 Answers  

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,

Why Multiload does not supports USI and supports NUSI?

4 Answers  

Is multi insert ansi standard?

0 Answers  

I want to write one query How to get Matched records and unmatched records in table?

4 Answers   TCS,

What is meant by Teradata Gateway?

0 Answers  

What are the available join types in teradata?

0 Answers  

What is the Maximum number of volatile tables that can be created?

4 Answers   Mphasis,

For more Teradata Interview Questions Click Here
Categories