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 are vaious etl tools in the market?
How to calculate fact table granularity?
what type of raid setup would you put your tx logs?
Explain the definition of normalized and denormalized view?
Where we use surrogate key explain with example?
How we are using this function?
Explain the main difference between inmon and kimball philosophies of data warehousing?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
Explain what is a cube in data warehousing concept?
Define data warehouse?
What are the reasons to use a chameleon method in data warehousing?
Explain what are non-additive facts in detail?
Explain what is full load & incremental or refresh load?
What are the different types of fact tables used in data warehousing?
Explain difference between view and materialized view?