Interested to Buy Any Domain ? << Click Here >> for more details...
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 the use of incremental aggregation? Explain me in brief with an example?
What is surrogate key? Explain with examples.
Explain what is the difference between power center & power mart?
What are the advantages of raid 1, 1/0, and
How can you set the session management?
Explain a relation schema and a relation?
What is "method/1"?
Explain what are conformed dimensions?
What is batch processing?
Explain difference between data ware house & data mart?
How do you define data block size?
Explain bus schema?
What is the very basic difference between data warehouse and operational databases?
What is the main difference between star and snowflake star schema? Which one is better and why?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
