major difference between normal loading and bulk loading?

Answer Posted / james

The major difference is while going with normal load,we can
have session recovery whereas in Bulk loading we can't.
Some of the other differences are as follows:
Normal Bulk
1.Enters session log before 1.Doesn't enter the session
loading into target there by log and loads directly in
increasing the loading time. target there by decreasing
the loading time.
2.Less performance. 2.High performance.
3.Indexing possible. 3.No concept of indexing.
4For small amount of data. 4.For huge amount of data.

Please let me know if you have any further differences.
Thanks.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define mapplet?

627


Explain direct and indirect flat file loading (source file type) - informatica

837


draw informatica architecture 8.6 ?

3473


Explain lookup transformation source types in informatica

702


What is the reusable transformation?

634






how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1699


What is meant by LDAP users?

699


What is DR strategy for Informatica project?

706


Under which circumstances, informatica server creates reject files?

595


Define update strategy?

641


What do you understand by a term domain?

673


define galaxy repository in informatica

1729


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2430


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7772


How an expression transformation differs from aggregator transformation?

630