what is a hot file, why we need in datawarehousing, where
we used in general
- 2 Answers
- 6522 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 a Data Cube?
Explain what are fact, dimension, and measure?
Explain degenerate dimension table?
Give some difference between oltp and olap.
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain is olap databases are called decision support system true/false?
What are the key columns in Fact and dimension tables?
What is difference between model & package?
OLAP architecture?
in general which algorithms for used?
What are the different types of data warehouses?
What is BCP?
Teradata 
