Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Normal load and Bulk load?
- 5 Answers
- 50991 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / harithareddy
normal load performance recovery is possible where as in
bulk mode it is not possible bez, there is no databaselog
to perform rollback
| Is This Answer Correct ? | 44 Yes | 4 No |
Answer / sachin
1.It is also not allow the constraint when we make Target load type as Bulk Mode
2.Also we do not allow to use indexes on database level in Bulk mode But in Normal mode we can allow indexes as well as constraint.
| Is This Answer Correct ? | 1 Yes | 0 No |
explain about unit testing? in real time?
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
Can we create out put ports in source qualifier t/r?
What are the active and passive transforamtions?
without using emailtask how will send a mail from informatica?
how to we create datamart?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
How union transformation is used?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
What do you mean incremental aggregation?
What happens when a session fails and you click on recover?
Teradata 
