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
What are the scenarios in which full table scans occurs?
List the logical and conditional operators that are used with teradata along with their meanings?
What are the components used in smp and massively parallel processing (mpp) machines?
What are the advantages of teradata?
Highlight the points of differences between the database and user in Teradata.
What is a three-tier data warehouse?
What are some commonly used bteq scripts?
What happens when a node suffers a downfall?
What is teradata? Also, list out some of the primary characteristics of teradata.
Explain vproc in teradata?
How does hashing happens in teradata?
What is the purpose of upsert command?
What are the 5 phases in a multiload utility?
Highlight the differences between Primary Key and Primary Index.
how many modules are there in telecome domain?how to explain the architecture?