HI Experts,
What is BULK mode and NORMAL mode, Which one gives better
performance. How? Please Explain with an example...! It
will help's me a lot.
Thanks In advance.
Answer Posted / pardhu
when u configure the session with the type normal the I.S
writes the data records to database log before inserting the
rows into target. when u configure the session with the type
bulk the I.S bypasses the database log it inserts the
records directly into target. In normal mode session
recovery is possible but in bulk mode session recovery is
not possible. bulk mode improves the performance.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the procedure for creating independent data marts from informatica 7.1?
Whats there in global repository
What is data movement mode in Informatica and difference between them?
How can we handle two sessions in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is standalone command task?
In informatics server which files are created during the session rums?
What is the cumulative sum and moving sum?
What is meant by active and passive transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are some examples of informatica etl programs?
What are the different clients of powercenter?
How to generate sequence numbers?
update strategy transformation in informatica
What are the different types of repositories created using informatica?