can I use “drop” statement in the utility “fload”?
Answers were Sorted based on User's Feedback
Answer / sat!sh
YES,
But you have to declare it out of the FLOAD Block it means
it should not come between .begin loading,.end loading
FLOAD also supports DELETE,CREATE,DROP statements which we
have to declare out of FLOAD block
in the FLOAD Block we can give only INSERT
----
Hi Friends Got a Best ANS share with us :)
Is This Answer Correct ? | 38 Yes | 1 No |
Answer / tdguy
FLOAD--PHASES--2;
MAXIMUM TABLES that can be loaded--1;
DML STATEMENTS SUPPORTED--INSERT;
DDL STATEMENTS SUPPORTED--CREATE,DROP;
ERROR TABLES TO BE DEFINED--YES;
WORK TABLES TO BE DEFINED--NO;
Is This Answer Correct ? | 8 Yes | 0 No |
Highlight the advantages of PPI(Partition Primary Index).
What is the difference between global temporary tables and volatile temporary tables?
What is a dimension table?
What is the process to restart the multiload if it fails?
List out all forms of LOCKS that are available in Teradata.
What are the multiload utility limitations?
Explain the most common data types used in teradata?
what are the default access rights in the teradata?
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.
Explain the new features of teradata?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
How do you determine the number of sessions?