Interested to Buy Any Domain ? << Click Here >> for more details...
What is Bulk Insert?
- 3 Answers
- 12225 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 |
Explain what are the basic needs to join two sources in a source qualifier?
Explain what are components of report studio?
what is an use case?
0 Answers InfoAxon Technologies,
What is a ETL/ How does Oracle support the ETL process?
Where can one get more info about Data Warehousing?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is a fact, dimension, measure?
What are the types of dimensional modeling?
How to limit the max no of rows retrieved in the report?
What is power play plug in?
What is the difference between star and snowflake schemas?
What is the difference between filter and lookup transformation?
Teradata 
