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
What is the primary index in teradata?
Describe primary index in teradata?
What is the meaning of Caching in Teradata?
What are some primary characteristics of teradata?
What is the maximum number of dml can be coded in a multiload script?
What are the steps to create a data model?
What is dimensional modeling?
Why is the case expression used in teradata?
What is teradata?
What are the functions involved in shared information architecture?
List the logical and conditional operators that are used with teradata along with their meanings?
Highlight the differences between Primary Key and Primary Index.
List out all forms of LOCKS that are available in Teradata.
What is partitioned primary index (ppi)?
What are the advantages of teradata?