what is a hot file, why we need in datawarehousing, where
we used in general
- 2 Answers
- 6967 Views
- Thomson, I also Faced
- E-Mail Answers
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 |
what is the difference between DSS and ODS ?
What is a relationship?
What is DTS ?
What is confirmed dimension?
Explain what is cost benefit analysis (cba)?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What is DTM session?
What is difference between query studio and report studio?
what are the others of "bad files" and "discard files" when using sql*loader?
What is the main difference between inmon and kimball philosophies of data warehousing?
What are parallel querys and query hints?
What is the difference between static cache and dynamic cache?
Teradata 
