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 is the main difference between inmon and kimball philosophies of data warehousing?

854


Explain what is the difference between datawarehouse and bi?

716


What is degenerate dimension table?

741


Is there any default username & pwd for bo designer & supervisor?

749


How to create diff. Types of templates?

720






Explain what is the data type of the surrogate key?

749


Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

744


Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

686


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

653


What is a relationship?

728


What is a view as it relates to system modeling?

741


Explain what is cost benefit analysis (cba)?

707


What are target types on the server?

726


What is the difference between view filter and report filter?

687


What is junk dimension? What is the difference between junk dimension and degenerated dimension?

799