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

major difference between normal loading and bulk loading?

Question Posted / james

Answer Posted / james

The major difference is while going with normal load,we can
have session recovery whereas in Bulk loading we can't.
Some of the other differences are as follows:
Normal Bulk
1.Enters session log before 1.Doesn't enter the session
loading into target there by log and loads directly in
increasing the loading time. target there by decreasing
the loading time.
2.Less performance. 2.High performance.
3.Indexing possible. 3.No concept of indexing.
4For small amount of data. 4.For huge amount of data.

Please let me know if you have any further differences.
Thanks.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete duplicate row using informatica?

1030

What is substr in informatica?

1198

What are the different ways to implement parallel processing in informatica?

1415

Can we change Dynamic to Static or Persistent cache? If so what happens?

2200

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1574

how to load rows into fact table in data warehouse

1176

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

1102

Target increases every day even though no new record was inserted

1569

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7177

Explain pushdown optimization $pushdownconfig parameter - informatica

1121

How to load the data from a flat file into the target where the source flat file name changes daily?

1047

What are the performance considerations when working with aggregator transformation?

1145

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2715

What is rank transform?

990

can anyone suggest best free Talend data integration training online

1688