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
I know of using applysimple, but there are other ways too?
Describe a data warehouse.
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
ware house management system is used?
What is surrogate key? Explain with examples.
What are non-additive facts in detail?
Explain can report net connect multiple datasource at a time in report creation time?
How to reduce warnings?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
Where the data cube technology is used?
What are the different problems that ?Data mining? can solve?
Explain what is ods (operation data source)?
What is a source qualifier?