Answer Posted / 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 |
Post New Answer View All Answers
What is Cognos script editor?
What is your spectra photometer working principles?
What are components of reportnet?
How to export mappings to the production environment?
What is type 2 version dimension?
Explain what is the advantages data mining over traditional approaches?
What are different deliverables according to phases?
What is the extension of file to save template?
What are the different types of fact tables used in data warehousing?
What are components of report studio?
What is the definition of cube in datawarehousing?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is meant by metadata in context of a data warehouse and how it is important?
in general which algorithms for used?
Ist the schema that a data warehouse system can implements.