can I use “drop” statement in the utility “fload”?
Answer Posted / 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 |
Post New Answer View All Answers
What does sleep function does in fast load?
How do you do backup and recovery in teradata?
Explain the term 'primary key' related to relational database management system?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
How do you determine the number of sessions?
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?
Highlight the need for Performance Tuning.
Describe the between keyword in teradata?
What are different table types used in teradata?
What are aggregate tables? How do you design them using teradata?
What does Amp contain and what are all the operations that it performs?
What is a sparse index?
What is node? How many nodes and amps used in your previous project?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are default access rights in teradata?