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

How to create prompts in report net?

0 Answers  


What are the tools available for etl?

0 Answers  


What is the difference between filter and lookup transformation?

0 Answers  


What is metadata in context of a datawarehouse and how it is important?

0 Answers  


How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

0 Answers  






if source contain 10records how you identify header and footer

2 Answers   Polaris,


What is up date strategy and what are th options for update strategy?

2 Answers  


Explain grouped cross tab?

0 Answers  


Explain the difference between oltp and olap?

0 Answers  


What is a Decision Tree Algorithm?

0 Answers  


Explain the main difference between inmon and kimball philosophies of data warehousing?

0 Answers  


Explain the definition of normalized and denormalized view?

0 Answers  


Categories