Interested to Buy Any Domain ? << Click Here >> for more details...
can I use “drop” statement in the utility “fload”?
- 2 Answers
- 17225 Views
- Accenture, CTS, NTT Data, I also Faced
- E-Mail Answers
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 |
What are the uses of client software involved in teradata?
Explain teradata architecture?
What is the Maximum number of volatile tables that can be created?
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
What are differences between teradata and ansi session modes in teradata?
What is oltp?
What is database exceptions in teradata?
what is use of PI(primary index) AND SI(secondary index)
How is Teradata in current market?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What's the difference between timestamp (0) and timestamp (6)?
Highlight all the modes that are present under Confidence Level.
Teradata 
