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
- 15598 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 the function of look up transformation?
How do you load only null records into target?
What is dimensional table? Explain the different dimensions.
What is a joiner transformation and why it is an active one?
What is a passive transformation?
what is Active lock explain
Explain the mapping variable usage example in informatica
What is domain in terms of informatica?
What is rank transform?
How to open an older version of an object in the workspace?
What is intricate mapping?
tell me the rules and responsblites in our project(my project is development)
Which development components of informatica have the highest usage?
How can you generate reports in informatica?
Performance tuning in UNIX for informatica mappings?
