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
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Explain teradata utilities. What is multiload, fast load, tpump?
In Teradata, how do we Generate Sequence?
Syntax for case when statement?
What are the different design perspectives used in teradata?
What is a level of granularity of a fact table?
Define views in teradata with syntax.
What is the opening step in basic teradata query script?
what is object level locking ? where do appear this type of locking ?
What are the scenarios in which full table scans occurs?
What are the components provided on node?
what are the uses of fact table and dimension table in banking project?
What are the steps to create a data model?
Highlight the limitations of TPUMP Utility.
What are the components used in smp and massively parallel processing (mpp) machines?