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 a dimension table?
What are the scenarios in which full table scans occurs?
Explain teradata utilities. What is multiload, fast load, tpump?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are the various indexes in teradata? How to use them?
Difference between star and snowflake schemas?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is a node in teradata? Explain
What is the purpose of indexes?
Explain teradata architecture in detail with a diagram.
What is the use of having index on table?
Which is more efficient group by or distinct to find duplicates?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the things to be considered while creating secondary index?
What is TPD?