If I have a index defined on target table and if set it to
bulk load will it work ?
- 4 Answers
- 14620 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 a pre-defined event and user-defined event?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the types of schemas we have in data warehouse.
How do you migrate data from one environment to another?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to create the source and target database connections in server manager?
What are the different types of repositories created using informatica?
What are the differences between a connected lookup and unconnected lookup?
Explain lookup transformation in informatica
What is a joiner transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Differentiate between reusable transformation and mapplet.
What are the informatica performance improvement tips
Explain the scenario which compels informatica server to reject files?
How to create Target definition for flat files?
