Interview Questions   Tutorials   Discussions   Programs   

Teradata - Fast Load Script is failed and error tables are available then how do you restart?




619
views
asked mar September 20, 2014 06:37 AM  

Fast Load Script is failed and error tables are available then how do you restart?


           

1 Answers



 
answered By vishnoiprem   0  
There are two ways

1.In case of Old file to Run 
Do not drop error tables simply rectify the error in the script or file and Run again.so that it runs from         last configuration.

2.In case of new file to Run
Drop Error tables and try to run the script with only begin and end loading statements, so that it          release the lock on target table.
If possible remove the record from fastlog table.
Run the script with new file freshly.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert