what is a hot file, why we need in datawarehousing, where
we used in general
Answer Posted / 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 |
Post New Answer View All Answers
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain what is a three tier data warehouse?
What is metadata in context of a datawarehouse?
What is core dimension?
What is the definition of cube in datawarehousing?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Difference between cold fusion 5 and cold fusion mx 6?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Explain what are the advantages data mining over traditional approaches?
Explain the different types of data warehousing?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
what are relationships?
What is difference between query studio and report studio?
What is a source qualifier?
What is ods (operation data source)?