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 |
what are different ways of loading data to data warehouse using oracle?
How to create prompts in report net?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is bi?
Explain about core dimension, balanced dimension, and dirty dimension?
What is data stream and data adaopter?
Can we take backup when the database is opened?
What is an OLTP (Online Transaction Processing) System?
Explain the definition of normalized and denormalized view?
Explain the structure of cold fusion?
What is index awareness in universe?
how much memory space occupied real time project (roughly)?