Interested to Buy Any Domain ? << Click Here >> for more details...
What is Bulk Insert?
- 3 Answers
- 12325 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bharat kalra
In informatica ..bulk insert or bulk load does 2 things :-
1) Ignores the commit interval specified at the session
level.
2) Do not create a database session log file.
So, advantage is it's very fast as no entry goes into log.
Disadvantage is session cannot be rolled back as no entry
exists in the log file .
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / justin wong
hi
there is another point.
we need to diable constraint before bulk.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / shweta
One clarification to the fisrt point,it ingnores the commit
point only while loading to Sybase and DB2 whereas for
Oracle and SQL Server, it commits data at each commit
interval and start a new transacton after each commit.
| Is This Answer Correct ? | 6 Yes | 2 No |
Why denormalization is promoted in universe designing?
What should I have in mind when building olap solution from scratch?
Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.
What is incremintal loading?
What are the various file formats involved in reportnet?
Explain which are the olap tools available that are supported by oracle?
After the complete generation of a report who will test the report and who will analyze it?
How to pivot row data using informatica?
What is Drill by? drill through?
What function should we use to display the value entered or selected by a user in response to a prompt?
if we increase the number of dimensions will the rows in fact table increase or decrease??
What are Data Marts?
Teradata 
