What is the difference between Bulk Load and Normal Load
Answer Posted / guest
Bulk loading,improves the performance of a session that
inserts a large amount of data to the target database.When
bulk loading, the Integration Service bypasses the database
log, which speeds performance. Without writing to the
database log, however, the target database cannot perform
rollback.As a result, you may not be able to perform recovery.
In normal load the databse log is not bypassed and therefore
the target databse can recover from an incomplete session.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Enlist few areas or real-time situations where informatica is required.
What is the surrogate key?
What are the various types of transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
what is the size of u r source(like file or table)?
Why update strategy and union transformations are active? Explain with examples.
Explain informatica architecture - version 8 / 9
Informatica settings are available in which file?
Can u generate reports in Informatica?
Which transformation should we use to normalise the COBOL and relational sources?
What is a pre-defined event and user-defined event?
How to create the source and target database connections in server manager?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain in detail scd type 2 through mapping.
What is repository manager?