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 / tdguy

Just rectify the errors in the file and resubmit the job.
Fload will take of duplicates and moves to uv table.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of client software involved in teradata?

540


What are the things to be considered while creating secondary index?

638


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

684


What is the use of having index on table?

586


What are the enhanced features in teradata v2r5 and v2r6?

695






What are the scenarios in which full table scans occurs?

544


What is called partitioned primary index (ppi)?

569


What is the syntax for case when statement?

594


What happens when a node suffers a downfall?

671


During the Display time, how is the sequence generated by Teradata?

619


Why does varchar occupy 2 extra bytes?

615


Different phases of multiload?

596


Define views in teradata with syntax.

646


Highlight the points of differences between the database and user in Teradata.

595


What does Amp contain and what are all the operations that it performs?

594