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


Please Help Members By Posting Answers For Below Questions

What are the functions of a Parser?

584


Describe the set operators in teradata.

563


How is MLOAD Client System restarted after execution?

575


List out teradata data types?

534


What are the enhanced features in teradata v2r5 and v2r6?

666






Different phases of multiload?

564


What is the difference between teradata and basic rdbms?

540


What is the difference between fastload and multiload? Which one is faster?

571


What is difference between user and database in teradata?

590


How do you verify a complicated sql?

601


Explain the term 'foreign key' related to relational database management system?

527


Explain some differences between mpp and smp?

568


Explain amp in teradata?

552


How to identify ppi columns?

632


Explain vproc in teradata?

542