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 / janardhanreddy yerraballi
Sometimes in bulk mode the session gets failed bcoz you cannot use bulk mode if the index is defined on the target table, so if you want to use bulk mode for indexed target table you have to drop abd recreate the index using pre and post sql command
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Enlist some properties of sessions.
When do you use sql override in a lookup transformation?
How to create a non-reusable instance of reusable transformations?
What is aggregate cache in aggregator transformation?
Briefly define a session task?
Which transformation is needed while using the Cobol sources as source definitions?
update strategy transformation in informatica
How do you take back up of repository?
Explain the different kinds of facts.
Please let me know how to make encryption and decryption with example?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is resilience time?
Explain the informatica workflow?
What is a stored procedure transformation?
Design time, run time. If you don't create parameter what will happen