what is a hot file, why we need in datawarehousing, where
we used in general
- 2 Answers
- 6721 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 metadata in context of a datawarehouse and how it is important?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What are the mapping paramaters and maping variables?
What are the methodologies of data warehousing?
Explain the main difference between inmon and kimball philosophies of data warehousing?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Explain meta data?
Explain what is the extension of file to save template?
Name a few sectors which use data warehousing?
if we increase the number of dimensions will the rows in fact table increase or decrease??
Explain me what are data marts?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
Teradata 
