Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bulk Load and Normal Load
- 3 Answers
- 13143 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srikanth
Bulk Load: It is preferable when the volume of data is huge
from source system. if we select bulk loading, integration
service doesn't create Database log, that's the reason we
cant perform session recovery.But bulk loading can improve
the performance of session.
Normal Load:If we select normal loading,integration service
create Database log before loading the data into Target.
This database log having the information of last ROWID of
the record for recent load data.it can support session
recovery.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How many dimensions are there in informatica?
How many input parameters can exist in an unconnected lookup?
What are the differences between source qualifier and joiner transformation?
How to call shell scripts from informatica?
Partition, what happens if the specified key range is shorter and longer
If informatica has its scheduler why using third party scheduler?
Which transformation is needed while using the Cobol sources as source definitions?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Mention some types of transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is source qualifier transformation in informatica?
What is union transformation?
Is there any target staging area in informatica not staging area
What is informatica metadata and where is it stored?
