Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bulk Load and Normal Load
- 3 Answers
- 13171 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / guest
Bulk loading,improves the performance of a session that
inserts a large amount of data to the target database.When
bulk loading, the Integration Service bypasses the database
log, which speeds performance. Without writing to the
database log, however, the target database cannot perform
rollback.As a result, you may not be able to perform recovery.
In normal load the databse log is not bypassed and therefore
the target databse can recover from an incomplete session.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Write the unconnected lookup syntax?
Explain target update override in informatica
What is olap (on-line analytical processing?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to do unit testing in informatica?
Explain the pipeline partition with real time example?
Explain sessions. Explain how batches are used to combine executions?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the new features of informatica 9.x in developer level?
What are mapplets?
What is a sequence generator transformation?
Could you explain what is enterprise data warehouse?
How does a sorter cache works?
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.
Explain dynamic target flat file name generation in informatica
