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 multivalued dependency?
What are the advantages of query studio compared to report studio?
What is ods (operation data source)?
Explain what is the metadata extension?
Explain the difference between view and materialized view?
How to know the time taken for particular report execution?
Explain normalization?
Explain what are the advantages of query studio compared to report studio?
What is aggregate fact table?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
Explain ddl (data definition language)?
How to create prompts in report net?
How to create diff. Types of templates?
List any five applications of data warehouse.
Explain what are components of reportnet?