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
What are templates in which way it is help full?
How to pivot row data using informatica?
What are the types of dimensional modeling?
Explain what are the basic needs to join two sources in a source qualifier?
Why denormalization is promoted in universe designing?
Explain the importance of data warehouse?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
Explain which are the olap tools available that are supported by oracle?
Explain what are slowly changing dimensions?
Explain what is a three tier data warehouse?
How to performance tune reports?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
Store (and count) non-fact records?
what are the other factors of the database on which the loading performance depend?