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?
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
How many codd's rules are satisfied by teradata database?
How do you verify a complicated sql?
What does Amp contain and what are all the operations that it performs?
What are teradata utilities?
What are the available join types in teradata?
What are the different softwares used with their functions in teradata?
Which is faster fastload or multiload?
What is primary index and secondary index?
What is the purpose of upsert command?
Explain fallback in teradata?
What are the multiload utility limitations?
Write a program to show the parser component used in teradata?
how many modules are there in telecome domain?how to explain the architecture?
What are the uses of client software involved in teradata?
What are the functions involved in shared information architecture?