Fast Load Script is failed and error tables are available
then how do you restart?

Answer Posted / vinay

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 Release locks on error tables
Run the script with new file freshly.
/*I am Teradata working professional and Faculty with 7+
yrs of exp posting for knowledge transfer to students.You
can reach me on teradatavinay@yahoo.com if more
clarification needed./*

Is This Answer Correct ?    11 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we collect statistics on multiple columns?

568


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

557


Difference between inner join and outer join?

587


Name the five phases that come under MultiLoad Utility.

586


What are the steps involved after the disk manager passes the request?

580






What is the difference between union and union all in teradata?

624


What is primary index and secondary index?

574


What is multi insert?

628


What is the opening step in basic teradata query script?

599


What can be achieved by using the teradata rdbms?

627


How to load specific no.of records using bteq, or fastload,or multiload

1318


Steps to create a data model?

662


What is node? How many nodes and amps used in your previous project?

673


What is database exceptions in teradata?

552


What are the various etl tools in the market?

587