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
What exactly do you know about catching in teradata?
If RDBMS is halted what will you do ?
What are the functions performed by bynet?
What happens when a node suffers a downfall?
Explain the term 'columns' related to relational database management system?
What are the joins in teradata and how many types of joins are there in teradata?
Explain fallback in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
How to load specific no.of records using bteq, or fastload,or multiload
What are the steps to create a data model?
Explain the new features of teradata?
Highlight the limitations of TPUMP Utility.
What are the commands to make a new table, change a table and remove a table in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is meant by a Least Cost Plan?