Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Normal load and Bulk load?
- 5 Answers
- 50980 Views
- I also Faced
- E-Mail Answers
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
Enlist the advantages of informatica.
What is xml source qualifier transformation in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is informatica worklet?
What is the use of target designer?
What is workflow monitor?
How can we use mapping variables in informatica? Where do we use them?
Where is metadata stored?
How would you join a node to the already existing domain?
what is the size of u r source(like file or table)?
Why sorter is an active transformation?
What is sequence generator transformation in informatica?
Slowly changing dimensions, types and where will you use them
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
