Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between normal and bulk loading?
Which one is recommended?
- 1 Answers
- 5890 Views
- I also Faced
- E-Mail Answers
Answer Posted / rakesh
The 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.
By configuring session to Bulk loading we cannot do 'session recovery' when it get failed whereas in normal loading we can easily do session recovery.
Note:In normal load Informatica creates logs record by record in database level and in bulk mode it will not create detail log. By avoiding that detail writing in bulk mode improve performance.
Note:If there are indexes and constraints in the table, you cannot use Bulk Load
You can drop/disable those indexes/constraints (pre session ) , then load the data (use Bulk Load) , and then create/enable the indexes/constraints (post session )
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
If informatica has its scheduler why using third party scheduler?
Where can we find the throughput option in informatica?
Under what condition selecting sorted input in aggregator may fail the session?
update strategy transformation in informatica
What are the new features of informatica 9.x in developer level?
What is the procedure for creating independent data marts from informatica 7.1?
What is the function of union transformation?
What is informatica? Why do we need it?
How to create Target definition for flat files?
What are the new features of Power Center 5.0?
what are the Methods For Creating Reusable Transformations?
How do you migrate data from one environment to another?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the types of caches in lookup? Explain them.
Explain the different dimensions.
