in what type of scenario bulk loading and normal loading we use?

Question Posted / mehul.thakur

2 Answers
5710 Views
Cognizant, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

in what type of scenario bulk loading and normal loading we use?..

We use bulk loading in such senarious where there is bulk amount of data is to be loaded into target.
ie we when we want yo load large amount of data fast into the target we use bulk loading.
when u dont want to do the session recovery and u r target should not contain any primary keys
we use normal loading in such senarious when u want to do session recovery.It looks about the constrain based
loding

Is This Answer Correct ?

3 Yes

0 No

in what type of scenario bulk loading and normal loading we use?..

Answer / amol palekar

main difference between normal and bulk load is, in normal load Informatica repository service create logs and in bulk load log is not being created. That is the reason bulk load loads the data fast and if anything goes wrong the data can not be recovered. But in normal load since the log is created the lost data can be recovered.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer