What is the difference between Normal load and Bulk load?
- 5 Answers
- 48380 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 |
What is repository manager?
how can we perform incremental aggregation?explain with example?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
how will compare two mappings in two different repository?
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
Explain dynamic target flat file name generation in informatica
Where should yoU place the flat file to import the flat file defintion to the designer?
how to join the two flatfiles using the joiner t/r if there is no matching port?
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
How to load a relational source into file taget?
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
Teradata 
