can I use “drop” statement in the utility “fload”?
- 2 Answers
- 10164 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 ? | 37 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 |
Why do Hash joins usually perform better than Merge Joins?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
Why FLOAD does not support multiset tables??
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
what is differences between Fastload and Multiload as per DBA aspect ?
What are the differences between TerdataV2R5 and V12 Versions please??
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
what is sysdba and sysdbc ? which has high priority ?
What is the process to restart the multiload if it fails?
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Teradata 
