What is the difference between Bulk Load and Normal Load
Answer Posted / prasad
Normal Load: Normal load option in session properties will
load records one-by-one and generate log for the informztion.
Bulk load: It will load all records at a time and did not
generate session log for records.. when you enable bulk load
the IS invokes sql loaders and bypass database log.
in normal we can able to recovery session
but bulk load cannot recover the sesion
..correct me if i am wrong
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to load data in informatica ?
What is rank transformation?
What are the tuning techniques you applied during your last project
How can we improve session performance in aggregator transformation?
What is rank index in rank transformation?
What do you understand by term role-playing dimension?
Which are the different editions of informatica powercenter that are available?
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
What is primary and backup node?
How can we delete duplicate rows from flat files?
Can anyone tell me the new features in Informatica 9 Version?
What are the uses of etl tools?
What is aggregator transformation in informatica?
Can we create two repositories on same database instance in oracle?
Design a mapping to load a target table with the following values from the above source?