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

Can any one plz provide the teradata interview questions?

10 Answers  


What do you mean by parsing?

0 Answers  


Which Teradata concept allows more than one model generation?

1 Answers   TCS,


IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 Answers  


What is Difference b/w PI & PPI?how to implement PPI?

3 Answers   Wipro,






hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com

0 Answers  


write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers   IBM,


What is a dimension table?

0 Answers  


Which is faster fastload or multiload?

0 Answers  


In Teradata, what is the significance of UPSERT command?

0 Answers  


"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

9 Answers  


Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,






Categories