What is the difference between Bulk Load and Normal Load
Answer Posted / srikanth
Bulk Load: It is preferable when the volume of data is huge
from source system. if we select bulk loading, integration
service doesn't create Database log, that's the reason we
cant perform session recovery.But bulk loading can improve
the performance of session.
Normal Load:If we select normal loading,integration service
create Database log before loading the data into Target.
This database log having the information of last ROWID of
the record for recent load data.it can support session
recovery.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
what is the complex transformation you used in informatica
What do mean by local and global repository?
what is Active lock explain
How is union transformation utilized?
What are the types of caches in lookup? Explain them.
What are the new features of informatica 9.x at the developer level?
How to improve the performance of a session using sorter transformation?
What is expression transformation?
explain about unit testing? in real time?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to call shell scripts from informatica?
Explain the aggregator transformation?
What is main use of mapplet?
What are junk dimensions?
What are mapplets? How is it different from a Reusable Transformation?