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
Explain the term 'columns' related to relational database management system?
What are teradata utilities?
What is the purpose of using case expression in teradata?
What is meant by a Channel Driver?
Explain the most common data types used in teradata?
What are the functions of a teradata dba?
what is object level locking ? where do appear this type of locking ?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What are some commonly used bteq scripts?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is the purpose of joins in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
What is the difference between fastload and multiload? Which one is faster?
Explain teradata utilities?
Define views in teradata with general syntax.