what is a hot file, why we need in datawarehousing, where
we used in general
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 |
in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do
What is Operational Data Store?
What are the main steps to build the data warehouse?
Explain what are fact, dimension, and measure?
What is DTM session?
What are the possible data marts in retail sales?
what are different ways of loading data to data warehouse using oracle?
Explain degenerate dimension table?
explain about dirty dimension?
What are components of reportnet?
What is surrogate key? Where we use it? Explain with examples.
Can we have more than one time dimensions in a Schema(Star or Snowflake)