Fast Load Script is failed and error tables are available
then how do you restart?
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 |
What is the difference between teradata and basic rdbms?
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is differnce between Error code and Error Level in Bteq
What do you mean by ttu in teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Discuss the advantages of using partitioned primary index in a query?
In your project what type of issues and errors you facing in Teradata
How many tables can you join in v2r5?
How is the teradata different from oracle?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
How many codd's rules are satisfied by teradata database?