What is Bulk Insert?

Answers were Sorted based on User's Feedback



What is Bulk Insert?..

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

What is Bulk Insert?..

Answer / justin wong

hi
there is another point.
we need to diable constraint before bulk.

Is This Answer Correct ?    5 Yes 0 No

What is Bulk Insert?..

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

Post New Answer

More Data Warehouse General Interview Questions

What is the difference between aggregate table and materialized view?

0 Answers  


how much memory space occupied real time project (roughly)?

0 Answers  


Explain vldb?

0 Answers  


Explain differences between star and snowflake schemas?

0 Answers  


Explain what are necessary tasks to install reportnet software?

0 Answers  






What is incremintal loading?

0 Answers  


What do you mean by static and local variable?

0 Answers  


What are data modeling and data mining?

0 Answers  


What is source qualifier?

2 Answers  


What is the main difference between schema in rdbms and schemas in datawarehouse?

0 Answers  


What are the tools available for etl?

0 Answers  


What is partitioning? What are the types of partitioning?

0 Answers  


Categories