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 inner join and outer join?
how to load or extract the error table data ?
what are the day to day activities of teradata DBA ?
what is identity columns in TD?
Explain and compare pros and cons of snow flake schemas?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
how many modules are there in telecome domain?how to explain the architecture?
How do you Generate Sequence in Teradata?
Write a program to show the parser component used in teradata?
What are the main components of teradata system?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
what are the roles and responsibilities of teradata DBA ?