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 does Amp contain and what are all the operations that it performs?
What are the string manipulation operators and functions associated with teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
What are the available primary index types in teradata.
Describe primary index in teradata?
What is logical data model?
What is teradata? Also, list out some of the primary characteristics of teradata.
What do you mean by tpt in teradata?
how do you manage the production space. what are the proactive methods you can take ?
What is real time and near real time data warehousing?
What is the syntax for case when statement?
What is database exceptions in teradata?
Highlight the need for Performance Tuning.
What interface is used to connect to windows based applications?
What are the 5 phases in a multiload utility?