Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bulk Load and Normal Load
- 3 Answers
- 13174 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
Can you generate sequence numbers without using the sequence generator transformation?
What are the prerequisite tasks to achieve the session partition?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is target load order?
Define Pmrep command?
can anyone suggest best free Talend data integration training online
According to his methodology what all you need before you build a datawarehouse
Can we create a Integration service without a Repository service and vice versa?
Why is sorter an active transformation?
How can you differentiate between powercenter and power map?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is rank transformation in informatica
What are the guidelines to be followed while using union transformation?
What are the databases that informatica can connect to windows?
What are the new features of Power Center 5.0?
