Interested to Buy Any Domain ? << Click Here >> for more details...
what is a hot file, why we need in datawarehousing, where
we used in general
- 2 Answers
- 7634 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 |
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What is a fact, dimension, measure?
Suppose we want to display zero when null values coming to report how can we do that?
explain about dirty dimension?
What is data warehouse architecture?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What is the use of dimensional modeling in data warehousing?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
Explain normalization?
what role views play in dimensional modeling?
What are CUBES?
What is cubes?
Teradata 
