Interested to Buy Any Domain ? << Click Here >> for more details...
I want to load 1000 rcds using. FL for every 100 records
there is a check point.But script failed at 120 records,
when we are restarting the script, it starts from last ckpt,
but Target table contains populated data but FL doesnt
support existing data in target table. How can we load data
in FL?
- 4 Answers
- 10150 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kishore
as the fastload supports restartability....if the script fails after loading 120 records....restart the script by rectifying errors...later it starts from last failed point in the log table....starts record loading from 121....(FAST LOAD DOES NOT SUPPORT DUPLICATE RECORDS because of the restartability concept)
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What is the difference between global temporary tables and volatile temporary tables?
Explain the term 'primary key' related to relational database management system?
What are tpump utility limitations?
What are the frequently used data types in teradata?
Why does varchar occupy 2 extra bytes?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What are the various indexes in teradata? Why are they preferred?
What is the use of teradata system software?
Syntax for case when statement?
Did you write stored procedures in teradata?
What are the components provided on node?
How to eliminate product joins in a teradata sql query?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
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 are the different methods ot loading a dimension table? A fact table etc?
