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
Who needs data warehousing?
What is a relationship?
Why we use repository connectivity?
What are diagrams?
Explain why fact table is in normal form?
What are components of report studio?
What is cubes?
What is load manager?
Database in use is oracle?
What is called dimensional modelling?
Can any one explain the hierarchies level data warehousing.
Explain about core dimension, balanced dimension, and dirty dimension?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain what is real time data-warehousing?
How can you import tables from a database?
