What is the difference between Normal load and Bulk load?
Answer Posted / guest
If you enable bulk loading, the PowerCenter Server
bypasses the database log.This improves session performance.
But the disadvantage is that target database cannot perform
rollback as there is no database log.
In normal load the databse log is not bypassed and
therefore the target databse can recover from an incomplete
session.The session performance is not as high as is in the
case of bulk load
Is This Answer Correct ? | 81 Yes | 4 No |
Post New Answer View All Answers
How does a sorter cache works?
What are the prerequisite tasks to achieve the session partition?
How to create or import flat file definition in to the warehouse designer?
When do you use sql override in a lookup transformation?
What are the performance considerations when working with aggregator transformation?
What is the use of target designer?
Which is the t/r that builts only single cache memory?
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,
What is the use of source qualifier?
What is parallel processing in informatica?
Why update strategy and union transformations are active? Explain with examples.
differences between service based and product based?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to improve the performance of a session using sorter transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION