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
Parameter and variable differences
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain the types of transformations?
How you prepared reports for OLAP?
What does update strategy mean, and what are the different option of it?
What are the limitations of joiner transformation?
What are different types of transformations available in informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How to differentiate between the active and passive transformations?
What do mean by local and global repository?
Which transformation is needed while using the Cobol sources as source definitions?
update strategy transformation in informatica
Clarify the utilization of aggregator cache record?
which one is better performance wise joiner or look up