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
What is the difference between star and snowflake schemas?
What needs to be done while starting the database?
What is the difference between power center & power mart?
What is surrogate key? Explain with examples.
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
How to add a number to a macro variable?
Code the tables statement for a single-level (most common) frequency?
Explain er diagram?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Why should you put your data warehouse on a different system than your oltp system?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Suppose we want to display zero when null values coming to report how can we do that?
Explain where do we use semi and non additive facts?
What are fact, dimension, and measure?
How can you set the session management?