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
- 15749 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 |
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
enterprise datawarehouse your project phase by phase explain?
What are the advantages of using informatica as an etl tool over teradata?
how to create user defined function (udf) in informatica
What are the types of error logs available in Informatica?
what is procedure to use mapping variable in source qualifier transformation? with example
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
Can any one explain or sujjest some sites for scd mappings.Thank you
what is threshold error in informatica?
Write the unconnected lookup syntax?
why union transformation is active transformation?
Teradata 
