Interested to Buy Any Domain ? << Click Here >> for more details...
Fast Load Script is failed and error tables are available
then how do you restart?
- 3 Answers
- 15098 Views
- TCS, I also Faced
- E-Mail Answers
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
How would you load a very large file in teradata in general?
What is the use of virtual processor connectivity in teradata?
Explain teradata vs. Redshift?
How do you determine the number of sessions?
What happens when a node suffers a downfall?
In Teradata, how do we Generate Sequence?
Explain teradata utilities. What is multiload, fast load, tpump?
What are the uses of bynets in multi-node systems?
What is a node in teradata?
What are the design features involved in teradata?
What are some commonly used bteq scripts?
What is partitioned primary index (ppi)?
What is TPD?
What type of indexing mechanism do we need to use for a typical data warehouse?
Describe the between keyword in teradata?
