Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bulk Load and Normal Load
- 3 Answers
- 12965 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 |
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
what is difference between mapping and mapplet ?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
how u know when to use a static cache and dynamic cache in lookup transformation.
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
What is Code Page Compatibility?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
What are the different transaction levels available in transaction control transformation?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
In target table how to display the system time
How many ways are there to do 'remove duplicate records in informatica'?
Teradata 
