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
- 15228 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 do you determine the number of sessions?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What are the different functions included in the server software?
What are tpump utility limitations?
Different phases of multiload?
How to Extract data from multiple legacy systems?
In the Primary Index, what is the score of AMPs that are actively involved?
How do you set the session mode parameters in bteq?
What is dimensional modeling?
Comment whether bottleneck is an error or not.
What are some commonly used bteq scripts?
How do you see a ddl for an existing table?
if collect stats but it show low confidence why?
Why are oltp database designs not generally a good idea for a data warehouse?
Why does varchar occupy 2 extra bytes?
