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
- 15272 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?
if collect stats but it show low confidence why?
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
Explain the term 'row' related to relational database management system?
What is FILLER command in Teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Explain the term 'tables' related to relational database management system?
What is the purpose of upsert command?
What is meant by a Parsing Engine?
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
How to Extract data from multiple legacy systems?
Teradata 
