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
Can we collect statistics on multiple columns?
Explain the term 'foreign key' related to relational database management system?
Difference between inner join and outer join?
Name the five phases that come under MultiLoad Utility.
What are the steps involved after the disk manager passes the request?
What is the difference between union and union all in teradata?
What is primary index and secondary index?
What is multi insert?
What is the opening step in basic teradata query script?
What can be achieved by using the teradata rdbms?
How to load specific no.of records using bteq, or fastload,or multiload
Steps to create a data model?
What is node? How many nodes and amps used in your previous project?
What is database exceptions in teradata?
What are the various etl tools in the market?