What is the difference between Bulk Load and Normal Load
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
What is the benefit of session partitioning?
What is the command used to run a batch?
Explain scd type 3 through mapping.
Which is the t/r that builts only single cache memory?
Explain the different kinds of facts.
what is song in infrmatica...?
What is a passive transformation?
What is status code in informatica?
What is the different lookup cache(s)?
What is mapping debugger?
can we override a native sql query within informatica? Where do we do it?
wf dont have integration severances how you can run?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is meant by query override?