Work flow failed when it is set to Bulk mode but it was
successful
when set to normal mode y??(All the connections are fine and
exactly
correct)?
Answer Posted / satya
Hi floks,
There some limitations to the BULK mode. U cant use BULK
mode in the below cases.
1. target table is not relational
2. if the target is relational but a primary key is declared
or Index is created on any of the columns.
3. If the mapping contains Update strategy.
So as per myunderstanding issue could be any one of the
above reasons. Pls check.
Satya
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
Explain pmcmd command usage in informatica
Parameter and variable differences
How to do the error handling of if ur source is flatfiles?
wf dont have integration severances how you can run?
Slowly changing dimensions, types and where will you use them
Write the unconnected lookup syntax and how to return more than one column.
What is the different lookup cache(s)?
In which transformation you cannot drag ports into it?
Difference between Data and Index Caches?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
In how many ways we can create ports?
Have you worked with/created Parameter file
What differs when we choose the sorted input for aggregator transformation?
What is aggregator transformation in informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.