Interested to Buy Any Domain ? << Click Here >> for more details...
can I use “drop” statement in the utility “fload”?
- 2 Answers
- 17166 Views
- Accenture, CTS, NTT Data, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What are the different softwares used with their functions in teradata?
What is difference between user and database in teradata?
What are the different functions included in the server software?
How to Extract data from multiple legacy systems?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How is MLOAD Teradata Server restarted after execution?
Why Fload doesn’t support multiset table?
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?
Difference between star and snowflake schemas?
write lock is compatiable with which type of lock?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Explain the parallel data extension in teradata?
Teradata 
