what is a hot file, why we need in datawarehousing, where
we used in general

Answer Posted / shree uday

Hot File:If we generate a report from two different
database, at that time we go for Hot File.The only drawback
is it will occupy the whole space in the hard disk.

Need of DWH:if u want enterprise reporting and analysis
from your historical data.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the other names given to data warehousing?

656


What is data warehosuing hierarchy?

591


Explain what is full load & incremental or refresh load?

539


What are the steps involved in creating dimensional modeling process?

573


Can you state some of the innovations throughout history?

560






What is data mart in data warehouse?

543


What are situations where snowflake schema is better than star schema when the opposite is true?

571


What are data modeling and data mining? Where it will be used?

554


How can you set the client management?

579


How to export mappings to the production environment?

516


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

569


What is pre-emptive and non-pre-emptive?

570


List down some of the real time data-warehousing tools?

568


What is Analysis Services?

1651


What are the advantages of query studio compared to report studio?

512