what is a hot file, why we need in datawarehousing, where
we used in general
- 2 Answers
- 6512 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 |
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is a Data Cube?
What are cursors?
Explain datawarehousing?
What are the different types of Fatcs? Explain with example only
What is the difference between Datawarehouse and OLAP?
I have two universes created by two difference database can we join them in designer & report level? How
How to design file watch jobs?
What is the difference between constraind base load ordering and target load plan?
Explain the differences between normalizer and normalizer transformation?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What are the key columns in Fact and dimension tables?
Teradata 
