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 / mahesh raja
Fastload will load the records in to target table
after .END LOADING statement only, so the extra 20 records
wont populate in target table so restart will work from 101
record onwords.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why does varchar occupy 2 extra bytes?
What is database exceptions in teradata?
Highlight the limitations of TPUMP Utility.
Did you write stored procedures in teradata?
What are the things to be considered while creating secondary index?
Explain the new features of teradata?
What are normalization, first normal form, second normal form and third normal form?
What are the joins in teradata?
How do you determine the number of sessions?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the scenarios in which full table scans occurs?
How would you load a very large file in teradata in general?
Name the five phases that come under MultiLoad Utility.
Define views in teradata with general syntax.
What is the purpose of joins in teradata and what are the available join types?