Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bulk Load and Normal Load
- 3 Answers
- 13109 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Bulk loading,improves the performance of a session that
inserts a large amount of data to the target database.When
bulk loading, the Integration Service bypasses the database
log, which speeds performance. Without writing to the
database log, however, the target database cannot perform
rollback.As a result, you may not be able to perform recovery.
In normal load the databse log is not bypassed and therefore
the target databse can recover from an incomplete session.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / 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 |
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 |
what is the location of parameter file in informatica?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
How would you copy the content of one repository to another repository?
How we can create indexes after completing the load process?
If we are using an aggregator but forget to mention the group by port .what will be the output??
how u know when to use a static cache and dynamic cache in lookup transformation.
i have 2 session s1 execute s2 load first session fail what is the reason?
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
What are variable ports and list two situations when they can be used?
what is lookupoverriding?
What is rank transformation?
Teradata 
