Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Normal load and Bulk load?
- 5 Answers
- 51194 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
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is dynamic cache?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Enlist the various types of transformations.
Which development components of informatica have the highest usage?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the scenario which compels informatica server to reject files?
What are the limitations of joiner transformation?
What are some examples of informatica etl programs?
What is data transformation manager process?
How can we create index after completion of load process?
Explain pushdown optimization and types in informatica
How do we call shell scripts from informatica?
