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
- 15377 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq
What is the difference between union and union all in teradata?
any one pls tell me what are the table names in banking project?
How can we load single row of data into teradata database. please give me the process.
If the script is aborted. why it is aborted and how can you identify ?
how teradata fetches a row from primary index table?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What are aggregate tables? How do you design them using teradata?
Explain the term 'columns' related to relational database management system?
What is FILLER command in Teradata?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
which option is used to restart the fast load script?
Teradata 
