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 teradata? Also, list out some of the primary characteristics of teradata.
What is a three-tier data warehouse?
How do you verify a complicated sql?
What are the frequently used data types in teradata?
What is smp and mpp platforms?
What are the functions of a teradata dba?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Explain and compare pros and cons of start schemas?
Describe the between keyword in teradata?
What are the various indexes in teradata? Why are they preferred?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is the difference between fastload and multiload? Which one is faster?
Highlight all the modes that are present under Confidence Level.
Describe primary index in teradata. And what are the available primary index types?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?