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
How is union transformation utilized?
How to Create a folder using pmrep command?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Explain the different kinds of facts.
What are ETL Tools?
What are the different versions of informatica?
Does an informatica transformation support only aggregate expressions?
While migrating the data from one environment to another environment how would you manage the connections?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is a joiner transformation and why it is an active one?
What is workflow? What are the components of workflow manager?
waht type of interface is used for testing the data in informatica
Enlist the tasks for which source qualifier transformation is used.
Sequence generator, when you move from develoment to production how will you reset
Define pmcmd command?