What is Bulk Insert?
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 |
When should you use a STAR and when a SNOW-FLAKE schema?
Explain functional dependency?
Explain normalization?
What is critical column?
How many ways we test the universe & Report?
What are the different models used in cluster analysis?
What are the types of SCD?
What is data mart in data warehouse?
What is freehand sql?
Explain conformed fact?
I need a good brd and uc template?
Compare ?Data mining? and ?Data Warehousing??