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 are the different functions performed in development phase?
Difference between star and snowflake schemas?
What are types of partition primary index (ppi) in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are the advantages of teradata?
Explain the meaning of Amp?
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.
What is Difference b/w PI & PPI?how to implement PPI?
Which Teradata concept allows more than one model generation?
What is the opening step in basic teradata query script?
What is differnce between Error code and Error Level in Bteq