What is the difference between narmal load and bulk load?



What is the difference between narmal load and bulk load?..

Answer / soumith avunoori

The main difference between normal and bulk load is, in normal load Informatica repository service create logs and in bulk load log is not being created. That is the reason bulk load loads the data fast and if anything goes wrong the data cannot be recovered.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

When should you use a STAR and when a SNOW-FLAKE schema?

6 Answers   Accenture,


What is the metadata extension?

0 Answers  


Where the data cube technology is used?

0 Answers  


in general which algorithms for used?

0 Answers  


What is the difference between data warehouse and operational systems?

0 Answers  






Give me a broad concept of what a data warehouse is, and what it might be used for?

2 Answers  


What is drill-through?

0 Answers  


What are aggregate tables and aggregate fact tables?

0 Answers  


explain about dirty dimension?

0 Answers  


I know of using applysimple, but there are other ways too?

0 Answers  


What is aggregate awareness?

2 Answers  


Tell me the Top 10 features of oracle that supports datawarehousing.

2 Answers   CTS, IBM,


Categories