Interested to Buy Any Domain ? << Click Here >> for more details...
can I use “drop” statement in the utility “fload”?
- 2 Answers
- 17168 Views
- Accenture, CTS, NTT Data, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
List out some of the primary characteristics of teradata.
How many tables can you join in v2r5?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is meant by a Parsing Engine?
How would you load a very large file in teradata in general?
Highlight the points of differences between the database and user in Teradata.
How to view every column and the columns contained in indexes in teradata?
What are the main components of teradata system?
what is object level locking ? where do appear this type of locking ?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Explain BYNET.
Why do you get spool space errors? How do trouble-shoot them?
What is the purpose of using case expression in teradata?
Differentiate database data and data warehouse data?
