What is the difference between normal and bulk loading?
Which one is recommended?
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 |
Explain the informatica workflow?
How do you load only null records into target?
How we can confirm all mappings in the repository simultaneously?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
tell me the push down optimization
How does the session recovery work.
How to load a Dimension ? and how to load a fact table?
What is persistent lookup cache?
how many session run unix environment what command using ?
what are types of dimentions?
What happens if the info. Server doesn't find the session parameter in the parameter file?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?