What is Bulk Insert?
- 3 Answers
- 12575 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 |
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
Why facts table is useful in representing the data?
How to create different types of templates?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is surrogate key?
What are Non-additive facts?
what are the all possible features supported modify stage?
what are the others of "bad files" and "discard files" when using sql*loader?
Explain how to generate iqd file from framework manager?
What is the difference between er modeling and dimensional modeling?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
Teradata 
