Can we load a Multi set table using MLOAD?
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 |
Give some points about Teradata Viewpoint ?
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?
What are the different functions included in the server software?
Did you write stored procedures in teradata?
How can we load single row of data into teradata database. please give me the process.
What is a common data source for the central enterprise data warehouse?
Difference between star and snowflake schemas?
How do you do backup and recovery in teradata?
What are the 5 phases in a multiload utility?
What do you mean by teradata intellicloud?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
what is the default character set in teradata,,?