Interested to Buy Any Domain ? << Click Here >> for more details...
can I use “drop” statement in the utility “fload”?
- 2 Answers
- 17035 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 |
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
What are the updated features of teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
what are the file sizes in your project?
Different phases of multiload?
Can you connect multiload from ab initio?
What is real time and near real time data warehousing?
How to identify ppi columns?
How to copy teradata scripts from ur remote desktop to server machine?
What do you mean by ttu in teradata?
Describe the between keyword in teradata?
Teradata 
