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
if you use oracle sql*loader , how do you transform data with it during loading?
What are fact, dimension, and measure?
What is mean by aggregate aware?
What is a view as it relates to system modeling?
What are the key columns in Fact and dimension tables?
Explain some of modeling tools available in the market?
Define Data Warehousing?
What is a linked cube?
What needs to be done while starting the database?
Explain what are the advantages data mining over traditional approaches?
What are the different ways to represent the loading of dimension tables?
In microstrategy, how can we direct the sql generated to use a specifc table?
What is an er diagram?
Explain what is data validation strategies for data mart validation after loading process?
what are the all possible features supported modify stage?