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
- 5785 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
What is the use of target designer?
What is the maplet?
What are Dimensional table?
What is an active transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is a node in Informatica?
What is a code page?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
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?
What is rank index in rank transformation?
What are the features of complex mapping?
How are indexes created after completing the load process?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
On which transformations you created partitions in your project?
Whats the difference between informatica powercenter server, repositoryserver and repository?
