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
- 15394 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
Explain what are the different types of transformation available in informatica.
what is mean by complex business rule ?
What is a snowflake schema?
Differentiate between a database and data warehouse?
Under which circumstances, informatica server creates reject files?
Enlist the tasks for which source qualifier transformation is used.
Under what condition selecting sorted input in aggregator may fail the session?
which one is better performance wise joiner or look up
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the difference between router and filter?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How is union transformation utilized?
What are the uses of etl tools?
can we override a native sql query within informatica? How do we do it?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
