can I use “drop” statement in the utility “fload”?
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
What is logical data model?
What is teradata and why it is used?
How to run a query in teradata?
What is called partitioned primary index (ppi)?
What are the uses of client software involved in teradata?
What do you mean by fastexport in teradata?
What is a three-tier data warehouse?
any one answer me how they can analyzing the project using data ware housing?
Explain PDE.
What does Amp contain and what are all the operations that it performs?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Why are oltp database designs not generally a good idea for a data warehouse?
Explain how spool space is used.
How is the teradata different from oracle?
Which is faster fastload or multiload?