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
Is union transormation is active transformation?
What is the difference between static cache and dynamic cache?
What is the use of tabular model, tabular sql, tabular reference in real time application?
How to test report in reportnet?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
explain about dirty dimension?
Define data warehouse?
What is the purpose of cluster analysis in data warehousing?
What is index awareness in universe?
What are the steps to build the datawarehouse?
What is your spectra photometer working principles?
What is the difference between connected and unconnected stored procedures?
What is the definition of cube in datawarehousing?
What is the advantages data mining over traditional approaches?
What are the types of SCD?