1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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?

Question Posted / subbu

Answer Posted / subbu

I agree with your statement using FLOAD we can't load the
data into a table which already contains the data this is
valid at intial run of FLOAD.

But here in our case the script was failed after loading
120 records and we have a check point option at 100
records.So one entry will be there in the log table after
100 records loaded into the table,as FLOAD utilty has the
automatic restart capability.It will start from 101 record
not from 121 record and the records from 101 to 120 already
loaded into the table It will omit those 20 records(from
101 to 120)and those will be loaded into the Errortable2(UV
table) remaining records from 121 to 1000 will be loaded
into target table.

Hope the above answer make it clear ur Question.

Regards
Subbu

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List out teradata data types?

564

What is a node in teradata? Explain

605

How is MLOAD Client System restarted after execution?

606

What is inner join and outer join?

620

What are the functions of a Parser?

618




What are default access rights in teradata?

632

Explain teradata architecture?

638

What is meant by a Highest Cost Plan?

630

What is meant by a Least Cost Plan?

630

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1902

Syntax for case when statement?

616

What is the difference between teradata and oracle?

560

Explain the advantages of partitioned primary index in a query?

571

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1777

what is sysdba and sysdbc ? which has high priority ?

3376