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
explain one complex mapping with logic? sales project?
How can you differentiate between powercenter and power map?
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?
What does command task mean?
Explain the shared cache and re-cache?
How to load data in informatica ?
How to update or delete the rows in a target, which do not have key fields?
To import the flat file definition into the designer where should the flat file be placed?
How can repository reports be accessed without sql or other transformations?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the new features of Power Center 5.0?
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
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is the sequence generator transformation in informatica?
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