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
- 15603 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / parikhita prusty
Bulk load never support the index.so if index in target with
bulk load the session will fail.so before use bulk load u
have to drop index in target,Normal load supports index.
| Is This Answer Correct ? | 21 Yes | 0 No |
Answer / surya
Bulk load never support the index.so if index in target with
bulk load the session will fail.so before use bulk load u
have to drop index in target and recreate index using
target post sql
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / babu
Hi Frnds,
Bulk load support if the target has index.but u have to
disable the ENABLE PARALL MODE OPTION in the connection
object tab.
Navigation:
WrkflowManager==>connections(Tab)==>Relationalconnection==>
Objects==>object name==>Edit==>Attributes==>Enable Parallel
Mode(check box)
By default it was enabled.
Thanks &Regards
Babu
8861145051
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
Difference between task flow and linear task flow
what is difference between dimention table and fact table?
how to obtain performance data for individual transformations.
is it possible to index the data in cache of lkp transformation ?
What are the different components of powercenter?
explain about unit testing? in real time?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How do you implement scheduling in Informatica?
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
what are objects in data warehouse?
Teradata 
