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
- 10149 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
Describe primary index in teradata?
Comment whether bottleneck is an error or not.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain the term 'database' related to relational database management system?
what are the uses of fact table and dimension table in banking project?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What do high confidence, low confidence and no confidence mean in explain plan?
What exactly do you know about catching in teradata?
What are the joins in teradata?
What is the purpose of using case expression in teradata?
Highlight the differences between Primary Key and Primary Index.
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
how do you manage the production space. what are the proactive methods you can take ?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
any one answer me how they can analyzing the project using data ware housing?
