Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What is the difference between normal and bulk loading?
Which one is recommended?

Question Posted / ram


What is the difference between normal and bulk loading? Which one is recommended?..

Answer / rakesh

The main difference between normal and bulk load is, in normal load Informatica repository service create logs and in bulk load log is not being created. That is the reason bulk load loads the data fast and if anything goes wrong the data can not be recovered. But in normal load since the log is created the lost data can be recovered.

By configuring session to Bulk loading we cannot do 'session recovery' when it get failed whereas in normal loading we can easily do session recovery.

Note:In normal load Informatica creates logs record by record in database level and in bulk mode it will not create detail log. By avoiding that detail writing in bulk mode improve performance.

Note:If there are indexes and constraints in the table, you cannot use Bulk Load
You can drop/disable those indexes/constraints (pre session ) , then load the data (use Bulk Load) , and then create/enable the indexes/constraints (post session )

Is This Answer Correct ?    14 Yes 0 No

Post New Answer

More Informatica Interview Questions

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

What is persistent lookup cache?

0 Answers  

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

What is an aggregator transformation?

0 Answers  

In which circumstances that informatica server creates Reject files?

2 Answers  

What is union transformation in informatica?

0 Answers  

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

how to join two flat files in informatica?

3 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories