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
Define mapplet?
Explain direct and indirect flat file loading (source file type) - informatica
draw informatica architecture 8.6 ?
Explain lookup transformation source types in informatica
What is the reusable transformation?
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
What is meant by LDAP users?
What is DR strategy for Informatica project?
Under which circumstances, informatica server creates reject files?
Define update strategy?
What do you understand by a term domain?
define galaxy repository in informatica
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?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How an expression transformation differs from aggregator transformation?