Interested to Buy Any Domain ? << Click Here >> for more details...
What is Bulk Insert?
- 3 Answers
- 12366 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 is query optimizer? what are different types of optimizer s supported by oracle ?
3.What is fact less fact ?
9 Answers Accenture, HCL, TCS,
What is the goal of optimizer?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain what are the vaious etl tools in the market?
What is surrogate key? Explain with examples.
Explain what are the advantages of query studio compared to report studio?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is incremintal loading?
What is multi-dimensional analysis?
How we are using this function?
What is a relationship?
Teradata 
