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 get the first 100 rows from the flat file into the target?
What is the difference between power center and power mart?
What is bi?
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain dimensional modelling?
How do you define data block size?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is drill-through?
What is MODEL is Data mining world?
How to stop a batch?
Can we have multiple application.cfm file in an application?
How many project sources we can create in metadata?
For faster process, what we will do with the universe?
How can you communicate with web server (apache or iis) from coldfusion?
Explain what are the various file formats involved in reportnet?