what is a hot file, why we need in datawarehousing, where
we used in general
Answer Posted / 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 |
Post New Answer View All Answers
Explain difference between view and materialized view?
Why fact table is in a normal form?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain what is a view as it relates to system modeling?
Explain the data type of the surrogate key?
Store (and count) non-fact records?
What is difference macros and prompts?
What is prompt types of prompts?use of prompts syntax of prompt?
What are different deliverables according to phases?
Compare cold fusion with other programming languages?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Which columns go to the fact table and which columns go the dimension table?
Explain what are slowly changing dimensions?
How to handle multi value dimensions?
Explain what is difference between query studio and report studio?