What is the difference between normal and bulk loading?
Which one is recommended?
- 1 Answers
- 4975 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Using Expression transformation how to remove duplicate records from a relational source?
Which one is better performance wise connected/un-connected lkp?why?
How does the session recovery work.
How Union Transformation is an Active Trans?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
What are the ETL tools available in DWH?
Can you start a batches with in a batch?
how to create user defined function (udf) in informatica
What are the tasks that can be performed using sq?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
How can you access the remote source into your session?
Explain the aggregator transformation?
Teradata 
