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 to calculate fact table granularity?
What is loop in data warehousing?
ware house management system is used?
Tell me what is degree of a relation?
Explain what are the mapping paramaters and maping variables?
Briefly state different between data ware house & data mart?
What are the steps to build the datawarehouse?
Suppose we want to display zero when null values coming to report how can we do that?
How to create different types of templates?
Explain the structure of cold fusion?
Explain er diagram?
What are aggregate transformation?
What is a general purpose scheduling tool?
What are data validation strategies for data mart validation after loading process?
How can we schedule the graph in unix?