What is the difference between Bulk Load and Normal Load
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
|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|
How can we use batches?
How we can get unique records into one target table and duplicate records into another target table??
What are the different tools in workflow manager?
Enlist the various types of transformations.
Can we insert and update a target table without using update strategy transformation?How?
What are the designer tools for creating tranformations?
what are the challenge face in u r project?explain me
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
task is running successfully but data is not loded why?
How can you validate all mappings in the repository simultaneously?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
can v update d records in target using update stargey without generationg primary key ? explain