Fast Load Script is failed and error tables are available
then how do you restart?
Answer Posted / vinay sir(datawarehousing tech
Guys, Small correction to the above answer.
Please read this latest answer.
There are 2 ways
1.Incase of Old file to Run
Dont drop error tables simply rectify the error in the
script or file and Run again.so that it runs from last
configuration.
2.Incase of new file to Run
Drop Error tables
Try to run the script with only begin and end loading
statements. ,so that it relases the lock on target table.
If possible remove the record from fastlog table.
Run the script with new file freshly.
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What are the functions of a Parser?
Describe the set operators in teradata.
How is MLOAD Client System restarted after execution?
List out teradata data types?
What are the enhanced features in teradata v2r5 and v2r6?
Different phases of multiload?
What is the difference between teradata and basic rdbms?
What is the difference between fastload and multiload? Which one is faster?
What is difference between user and database in teradata?
How do you verify a complicated sql?
Explain the term 'foreign key' related to relational database management system?
Explain some differences between mpp and smp?
Explain amp in teradata?
How to identify ppi columns?
Explain vproc in teradata?