what is a hot file, why we need in datawarehousing, where
we used in general
- 2 Answers
- 6487 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 ETL/ How does Oracle support the ETL process?
How to eliminate duplicate rows from flat file?
How are models actually derived?
In datastage can ve find the job based on source table name ??
Code the tables statement to produce a multi-level frequency?
What is freehand sql?
what are the different views that are considered when building an object-oriented software system?
0 Answers InfoAxon Technologies,
what type of raid setup would you put your tx logs?
How to limit the max no of rows retrieved in the report?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is a Data Cube?
What is Analysis Services?
Teradata 
