what is differences between Fastload and Multiload as per DBA aspect ?
Answer / vennela12
DBA want to check the table structure regarding load..
In Fload case table structure should have set table and index should be UPI
In Mload case table structure should have any table and any index
|Is This Answer Correct ?||4 Yes||3 No|
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
Is multi insert ansi standard?
Why Fload doesn’t support multiset table?
If table have access lock.In the same table write lock is posible or not?
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
if a error occured in FASTLOAD is the fastload job stops?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. firstname.lastname@example.org
What is the multi-insert?
Why Multiload does not supports USI and supports NUSI?
What is a sparse index?
What are the steps involved in the process flow of the sql statement through channel attached system?
in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that