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 sysdba and sysdbc ? which has high priority ?

0 Answers   Wipro,


What does Amp contain and what are all the operations that it performs?

0 Answers  


Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  


Difference between star and snowflake schemas?

0 Answers  


How to run a query in teradata?

0 Answers  


Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?

2 Answers  


How to run the Teradata jobs in unix environment ???

4 Answers   IBM,


What tools would you use for that?

0 Answers  


What is the opening step in basic teradata query script?

0 Answers  


What are the scenarios in which full table scans occurs?

0 Answers  


How teradata makes sure that there are no duplicate rows being inserted when its a set table?

0 Answers  


In the Primary Index, what is the score of AMPs that are actively involved?

0 Answers  


Categories