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?
- 4 Answers
- 8901 Views
- IBM, I also Faced
- E-Mail Answers
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
if collect stats but it show low confidence why?
what is object level locking ? where do appear this type of locking ?
How to load specific no.of records using bteq, or fastload,or multiload
What are default access rights in teradata?
How to select first n records in teradata?
Can you connect multiload from ab initio?
What are the various indexes in teradata? How to use them?
What are the various indexes in teradata? Why are they preferred?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is upsert statement in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is a node in teradata? Explain
What exactly do you know about catching in teradata?
How would you load a very large file in teradata in general?
Write a program to show the parser component used in teradata?
