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 |
How to answer the question how many fakt table in your datawarehouse and what size it have?
Explain what are the different types of join operations?
Explain what are the modules in power mart?
What is a functional dependency f said to be minimal?
What is crass reference table?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Are facts same as metrics and dimensions same as measures? If not , please tell the difference?
Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K
6 Answers Accenture, IBM, TCS,
Define data warehouse?
What is loop in data warehousing?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Why is business intelligence (bi) important in data warehousing?