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
- 15291 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the different softwares used with their functions in teradata?
Define views in teradata with general syntax.
What's the difference between timestamp (0) and timestamp (6)?
What is meant by a Channel Driver?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is the command in bteq to check for session settings ?
Explain PDE.
What are the updated features of teradata?
What are the various etl tools in the market?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Did you write stored procedures in teradata?
What are the different functions performed in development phase?
what is object level locking ? where do appear this type of locking ?
What do you mean by parsing?
What is spool space?
