If I have a index defined on target table and if set it to
bulk load will it work ?
- 4 Answers
- 14618 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Differences between connected and unconnected lookup?
What is dimensional table?
What is the Rank index port in Rank transformation?
How you can differentiate between connected lookup and unconnected lookup?
How can informatica be used for an organization?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Design a mapping to load the cumulative sum of salaries of employees into target table?
How many transformations can be used in mapplets.
What are the limitations of joiner transformation?
What is the difference between a repository server and a powerhouse?
Quickly characterize reusable change?
How to differentiate between the active and passive transformations?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are different types of transformations available in informatica?
How to load last n records of file into target table - informatica
