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
What is enterprise data warehousing?
how many types of dimensions are available in informatica?
update strategy transformation in informatica
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the surrogate key?
Explain the mapping variable usage example in informatica
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is a sorter transformation?
What are the static cache and dynamic cache in informatica?
What is an expression transformation?
How to extract sap data using informatica? What is abap? What are idocs?
How can you differentiate between powercenter and power map?
Explain about cumulative Sum or moving sum?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the performance considerations when working with aggregator transformation?