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

Aborted in Phase 2 data acquistion completed in fastload?

2 Answers  

Explain the meaning of Amp?

0 Answers  

What is a common data source for the central enterprise data warehouse?

1 Answers   Wipro,

What is the purpose of using case expression in teradata?

0 Answers  

Why are oltp database designs not generally a good idea for a data warehouse?

0 Answers  

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

0 Answers  

1.what is activity count? 2.what is skew factor? how it's working explain brefily

5 Answers   Satyam,

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 Answers   Cap Gemini,

What are types of partition primary index (ppi) in teradata?

0 Answers  

What's the syntax of sub string?

1 Answers  

What is oltp?

0 Answers  

For more Teradata Interview Questions Click Here
Categories