what is a hot file, why we need in datawarehousing, where
we used in general
Answers were Sorted based on User's Feedback
Answer / srinath rao.g
A hot file is a datasource by which we can develope .IMR
reports
.IMR reports can be developed in two ways
1.by catalog
2.by hot files
we can generate the reports by using two datasources at a
time with the help of HOTFILES.
WHERE AS does't support two datasources at a time.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
In document how to create metrics?
Explain vldb?
WHAT IS FACT LESS FACT TABLE?
What are the types of dimensional modeling?
Explain what are slowly changing dimensions?
What is a star schema? Why does one design this way?
What is operational data source (ODS)?
Why is business intelligence (bi) important in data warehousing?
Explain what is the difference between a primary and secondary actor in use case modeling?
Explain what is ods (operation data source)?
OLAP architecture?
Explain what are the different methods of loading dimension tables?