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




Answers were Sorted based on User's Feedback



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

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

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

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

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

Answer / tdguy

Rectify the errors and resubmit the script.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer



More Teradata Interview Questions

What is TPD?

0 Answers  


How to run a query in teradata?

0 Answers  


What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

5 Answers   Accenture,


Why Multiload does not supports USI and supports NUSI?

4 Answers  


What is database exceptions in teradata?

0 Answers  






How can bottlenecks be identified?

0 Answers  


Explain the most common data types used in teradata?

0 Answers  


Explain the types of join supports by teradata?

0 Answers  


i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

8 Answers   Satyam,


What is Join Index in TD and How it works?

6 Answers   BT, CSC, TCS,


Explain vproc in teradata?

0 Answers  


Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....

3 Answers  






Categories