If I have a index defined on target table and if set it to
bulk load will it work ?
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
Which transformation should we use to normalise the COBOL and relational sources?
How to extract sap data using informatica? What is abap? What are idocs?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explain incremental aggregation in informatica
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
tell me 5 session failure in real time how can you solve that in your project?
define galaxy repository in informatica
What is meant by LDAP users?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain transaction control transformation in informatica
What does “tail –f” command do and what is its use as an Informatica admin.
What is lookup transformation?
Explain sql transformation in script mode examples in informatica