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
- 15559 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 |
Why update strategy and union transformations are active? Explain with examples.
Define joiner transformation?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
According to his methodology what all you need before you build a datawarehouse
How to merge First Name & Last Name?
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
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. ?
How to handle changing source file counts in a mapping?
What is aggregate cache in aggregator transforamtion?
What are the differences between joiner transformation and source qualifier transformation?
Make a note of the quantity vaults made in informatica?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
Teradata 
