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
- 15758 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 |
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
what are the transformations that restricts the partitioning of sessions?
Can we override a native sql query within informatica?
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
what is normalizer transformation?
How is union transformation utilized?
Repository user profiles
Teradata 
