Interested to Buy Any Domain ? << Click Here >> for more details...
what is a hot file, why we need in datawarehousing, where
we used in general
- 2 Answers
- 7516 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 data cleaning? How can we do that?
What is the function of surrogate key in data warehousing?
What is data validation strategies for data mart v?
Explain the difference between data ware house & data mart?
Explain what are fact, dimension, and measure?
What is a look up function? What is default transformation for the look up function?
What is the difference between a primary and secondary actor in use case modeling?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What is the use of incremental aggregation? Explain me in brief with an example?
Can you pass sql queries in filter transformation?
What are the stages that are required in data warehousing?
How many types of facts and what are they?
Teradata 
