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 / kumar

Hi Friends,

Normally we have two types of loading. 1, Normal and 2. Bulk.

1 Normal: in this, data will load record by record and the integration service creates database log and is used in session because IS maintain the session log.

2 Bulk: In this, Data will insert Group of records, obviously bulk load will give better performance.

thanks,
kumar

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between a database and data warehouse?

650


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1584


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1617


Can informatica load heterogeneous targets from heterogeneous sources?

690


can we override a native sql query within informatica? Where do we do it?

620






How can we remove the duplicates from flat file source?

571


What are the different components of powercenter?

578


What is dimensional table? Explain the different dimensions.

647


How to open an older version of an object in the workspace?

612


draw informatica architecture 8.6 ?

3468


What are the performance considerations when working with aggregator transformation?

674


Explain the aggregator transformation?

623


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

707


What are the settings that you use to configure the joiner transformation?

611


How to load the data from people soft hrm to people soft erm using informatica?

557