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
Highlight all the modes that are present under Confidence Level.
Explain the term 'columns' related to relational database management system?
What is the meaning of Caching in Teradata?
What is primary index and secondary index?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How is MLOAD Teradata Server restarted after execution?
What is the difference between fastload and multiload? Which one is faster?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are some commonly used bteq scripts?
Difference between stored procedure and macro?
What is the basic syntax for teradata select statement?
What is the purpose of using case expression in teradata?
How do you determine the number of sessions?
What is the function of parser component in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com