Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Normal load and Bulk load?
- 5 Answers
- 51009 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 |
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
can you please explain me pre session and post session options?
I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)
3 Answers Alcatel-Lucent, ECI Telecom,
What is the Difference between sorter and aggregator?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
How to extract sap data using informatica? What is abap? What are idocs?
How can we store previous session logs?
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
How to update records in Target, without using Update Strategy?
Teradata 
