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
What are cluster analysis in data warehousing?
Explain what are the possible data marts in retail sales?
Explain the data type of the surrogate key?
What is core dimension?
Tell me what is full load & incremental or refresh load?
What is the difference between olap and oltp?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How can you implement many relations in star schema model?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain vldb?
What is dimensional modelling?
What are the advantages of raid 1, 1/0, and
Explain what are necessary tasks to install reportnet software?
I know of using applysimple, but there are other ways too?
What is data warehouse architecture?