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 is the use of teradata system software?
can we load 10 millions of records into target table by using tpump?
what is referential constraints?how do you implement RI in teradata?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
What are the advantages of teradata?
How do you set the session mode parameters in bteq?
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
Why do Hash joins usually perform better than Merge Joins?
What is the syntax for case when statement?
What is collect State in Teradata ? what it use and how it works??
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)