What is the difference between narmal load and bulk load?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Define data warehouse?

555


Explain how to export mappings to the production environment?

566


How to import vsam files from source to target. Do we need a special plugin?

515


How to pivot row data using informatica?

521


What is analytical or analytic mean?

620






What is bi?

575


What is the difference between olap and oltp?

560


What are session timeout and application timeout?

533


Suppose we want to display zero when null values coming to report how can we do that?

533


What is perform recovery?

547


What is aggregate fact table?

533


What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

570


Why null values are mapped as 0 in fact tables?

538


What is the purpose of Dataware Control?

604


What is the use of dimensional modeling in data warehousing?

542