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
- 6003 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 |
How do you implement configuration management in Informatica?
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
What is the functionality of update strategy?
what is data driven in update strategy transformation?
How to recover the standalone session?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
what is $$$$?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
What do you understand by term role-playing dimension?
What is version control in informatica ? Advance thanks
What is pmcmd command?
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
Teradata 
