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 to handle decimal places while importing a flatfile into informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is an unconnected transformation?
Where can we find the throughput option in informatica?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What are the databases that informatica can connect to windows?
What is a connected transformation?
What is the need of etl tools?
What is the difference between a connected look up and unconnected lookup?
What is the Rank index port in Rank transformation?
According to his methodology what all you need before you build a datawarehouse
What is informatica?
How to differentiate between the active and passive transformations?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
can anyone suggest best free Talend data integration training online