Interested to Buy Any Domain ? << Click Here >> for more details...
Can we load a Multi set table using MLOAD?
- 2 Answers
- 12451 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Explain the most common data types used in teradata?
What are the various reporting tools in the market?
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?
Explain about Skew Factor?
What is the syntax for case when statement?
What are the 5 phases in a multiload utility?
Differentiate database data and data warehouse data?
What is teradata? Also, list out some of the primary characteristics of teradata.
Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance
what is amp plz explanation
In BTEQ, how are the session-mode parameters being set?
What's the difference between timestamp (0) and timestamp (6)?
Teradata 
