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

Explain multivalued dependency?

636


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

570


What is ods (operation data source)?

646


Explain what is the metadata extension?

680


Explain the difference between view and materialized view?

597






How to know the time taken for particular report execution?

603


Explain normalization?

640


Explain what are the advantages of query studio compared to report studio?

629


What is aggregate fact table?

621


How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

627


Explain ddl (data definition language)?

657


How to create prompts in report net?

641


How to create diff. Types of templates?

642


List any five applications of data warehouse.

638


Explain what are components of reportnet?

623