Interested to Buy Any Domain ? << Click Here >> for more details...
What is Bulk Insert?
- 3 Answers
- 12371 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 |
What are the differences between datamart vs. Reporting cube?
Explain when do we analyze the tables? How do we do it?
How do you create surrogate key using ab initio?
What is difference between query studio and report studio?
Explain what are the methodologies of data warehousing?
What is a hash cluster?
What is normalization, first normal form, second normal form, third normal form?
What is data type of the surrogate key?
Explain meta data?
What is informatica architecture?
How to use the tool Ontobulider
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Teradata 
