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...

major difference between normal loading and bulk loading?

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

explain one complex mapping with logic? sales project?

6676


How can you differentiate between powercenter and power map?

1092


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1088


What does command task mean?

1155


Explain the shared cache and re-cache?

1121


How to load data in informatica ?

1026


How to update or delete the rows in a target, which do not have key fields?

1180


To import the flat file definition into the designer where should the flat file be placed?

1061


How can repository reports be accessed without sql or other transformations?

1224


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7071


What are the new features of Power Center 5.0?

1780


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7395


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2009


What is the sequence generator transformation in informatica?

1185


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1635