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 main use of mapplet?
What is the scenario which compels informatica server to reject files?
Why is sorter an active transformation?
Scheduling properties,whats the default (sequential)
Explain lookup transformation in informatica
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what is Active lock explain
what is the size of u r source(like file or table)?
What does reusable transformation mean?
What is confirmed fact in dataware housing?
Explain what transformation and how many are there in informatica?
r u done any partitions in ur project?
What is standalone command task?
What is meant by LDAP users?
difference between informatica 8.1.1 and 8.6