Fast Load Script is failed and error tables are available
then how do you restart?
Answer Posted / vinay sir(datawarehousing tech
Guys, Small correction to the above answer.
Please read this latest answer.
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 run the script with only begin and end loading
statements. ,so that it relases the lock on target table.
If possible remove the record from fastlog table.
Run the script with new file freshly.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is the difference between fastload and multiload? Which one is faster?
Explain amp in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
What are the joins in teradata and how many types of joins are there in teradata?
What's the difference between timestamp (0) and timestamp (6)?
How do you see a ddl for an existing table?
What is the basic syntax for teradata select statement?
Difference between stored procedure and macro?
Explain the advantages of partitioned primary index in a query?
Explain the most common data types used in teradata?
How does hashing happens in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Describe primary index in teradata. And what are the available primary index types?
What are the functions of a Parser?