HI Experts,
What is BULK mode and NORMAL mode, Which one gives better
performance. How? Please Explain with an example...! It
will help's me a lot.
Thanks In advance.
Answer Posted / pardhu
when u configure the session with the type normal the I.S
writes the data records to database log before inserting the
rows into target. when u configure the session with the type
bulk the I.S bypasses the database log it inserts the
records directly into target. In normal mode session
recovery is possible but in bulk mode session recovery is
not possible. bulk mode improves the performance.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Mention few advantages of router transformation over filter transformation.
Write the unconnected lookup syntax and how to return more than one column.
Performance tuning in UNIX for informatica mappings?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
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
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is an expression transformation in informatica?
When do you use sql override in a lookup transformation?
What are the informatica performance improvement tips
Write the different tools in the workflow manager?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
what is mean by complex business rule ?
where to store informatica rejected data?
Different sorts of metadata that stores in the storage facility?