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 are the functions of a teradata dba?
What is smp and mpp platforms?
What are some primary characteristics of teradata?
how can we analyze the locks ?
What are the various indexes in teradata? How to use them? Why are they preferred?
Steps to create a data model?
List out all forms of LOCKS that are available in Teradata.
What do high confidence, low confidence and no confidence mean in explain plan?
What is a three-tier data warehouse?
What are the newly developed features of Teradata?
What is the purpose of joins in teradata and what are the available join types?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is primary index and secondary index?
Explain teradata vs. Redshift?
What is meant by Teradata Gateway?