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
Which is more efficient group by or distinct to find duplicates?
If RDBMS is halted what will you do ?
How can bottlenecks be identified?
How to eliminate product joins in a teradata sql query?
What is spool space?
What do you mean by teradata intellicloud?
What are the different methods ot loading a dimension table? A fact table etc?
Highlight the limitations of TPUMP Utility.
What are the different softwares used with their functions in teradata?
What tools would you use for that?
What are teradata utilities?
List out teradata data types?
What is the maximum number of dml can be coded in a multiload script?
How many tables can you join in v2r5?
Explain the term 'row' related to relational database management system?