Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10480 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kishore
as the fastload supports restartability....if the script fails after loading 120 records....restart the script by rectifying errors...later it starts from last failed point in the log table....starts record loading from 121....(FAST LOAD DOES NOT SUPPORT DUPLICATE RECORDS because of the restartability concept)
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / 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 |
Answer / 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 |
if collect stats but it show low confidence why?
What are the things to be considered while creating secondary index?
While creating table my dba has fallback or no fallback in his ddl. What is that?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Why is the case expression used in teradata?
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Explain vproc in teradata?
Difference between Qualify and group
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
What is meant by a dispatcher?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
Teradata 
