Interested to Buy Any Domain ? << Click Here >> for more details...
If I have a index defined on target table and if set it to
bulk load will it work ?
- 4 Answers
- 15747 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / parikhita prusty
BULK LOAD DOESN'T SUPPORT THE INDEX.BULK LOAD BY PASSES LOG WHICH WE CAN'T RECOVER THE SESSION WHEN SESSION FAILS.MOSTLY WE USE INDEX FOR SELECT STATEMENT WHICH INCREASES THE PERFORMANCE WHEN WE INSERT THE RECORDIN A TABLE HAVIN INDEX IT DECREASES THE PERFORMANCE.SO BEFORE INSERT THE DATA IN THE TABLE WE HAVE TO DROP OR DISABLE THE INDEX WHICH INCREASES THE PERFORMANCE.NORMAL LOAD SUPPORT THE INDEX.
REGARD'S
PARIKHITA
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is meant by lookup transformation? Explain the types of lookup transformation?
How is union transformation utilized?
How we can create indexes after completing the load process?
What is target load order?
What is confirmed fact in dataware housing?
What is the benefit of session partitioning?
Describe expression transformation?
What are the different lookup cache(s)?
How to elaborate tracing level?
What are the new features of Power Center 5.0?
Can u generate reports in Informatica?
Explain the shared cache and re-cache?
Can anyone tell me the new features in Informatica 9 Version?
Where do we use mapping variables in informatica?
State the differences between sql override and lookup override?
