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 an use case?
What is ods (operation data source)?
How can we run the graph?
What is the difference between static cache and dynamic cache?
What is execution plan?
Explain the main differences between star and snowflake schema?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What is data mart in data warehouse?
What is scd1 , scd2 , scd3?
Explain hybrid slowly changing dimension?
what are different storage options supported by oracle ?
Explain what is difference between query studio and report studio?
How to design file watch jobs?
what is user variable in affinium campaign? and some real time examples.
What is the main difference between schema in rdbms and schemas in datawarehouse?