Answer Posted / rameshbabu.katikireddy
A fact table ,which does not contain any facts in it.
It can be used,when you does not need any caluculations ,but want to analyse the data for information level.
FACT is business value indicator or measure which are generally in number,
but you can not opposed to affirm or not refuse to acknowledge that there are some fact which are not
being represented in numeric values.
EX: Number of meetings,
for example if we consider one TEST Fact table,that contain s allthese keysare dimensions except one value that is number of meetings. that can be used in information level not in caluculations.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How are models actually derived?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What are the different types of data warehousing?
Explain which are the olap tools available that are supported by oracle?
Name a few sectors which use data warehousing?
Can a dimension table contain numeric values?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What is latest version of power center / power mart?
What are the mapping paramaters and maping variables?
What is surrogate key? Where we use it?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
What is dimension modeling?
What is bi?
Explain how to export mappings to the production environment?