Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is Bulk Insert?

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


Please Help Members By Posting Answers For Below Questions

What is Cognos script editor?

2609


What is your spectra photometer working principles?

1034


What are components of reportnet?

1131


How to export mappings to the production environment?

948


What is type 2 version dimension?

1014


Explain what is the advantages data mining over traditional approaches?

1066


What are different deliverables according to phases?

3464


What is the extension of file to save template?

1050


What are the different types of fact tables used in data warehousing?

1039


What are components of report studio?

1127


What is the definition of cube in datawarehousing?

1038


What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1103


What is meant by metadata in context of a data warehouse and how it is important?

1267


in general which algorithms for used?

2071


Ist the schema that a data warehouse system can implements.

991