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 |
When should you use a STAR and when a SNOW-FLAKE schema?
What is the metadata extension?
Where the data cube technology is used?
in general which algorithms for used?
What is the difference between data warehouse and operational systems?
Give me a broad concept of what a data warehouse is, and what it might be used for?
What is drill-through?
What are aggregate tables and aggregate fact tables?
explain about dirty dimension?
I know of using applysimple, but there are other ways too?
What is aggregate awareness?
Tell me the Top 10 features of oracle that supports datawarehousing.