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

What is the difference between view filter and report filter?

0 Answers  


What is the difference between power center and power mart?

0 Answers  


How to add a number to a macro variable?

0 Answers  


Where we use surrogate key explain with example?

0 Answers  


What is the difference between snowflake and star schema?

0 Answers  






What is multi-dimensional analysis?

3 Answers   Satyam,


What are the different problems that ?Data mining? can solve?

0 Answers  


Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

0 Answers  


How to generate the cubes in framework manager?

0 Answers  


What is the advantages data mining over traditional approaches?

0 Answers  


Define Data Warehousing?

0 Answers   Wipro,


How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

1 Answers  


Categories