Interested to Buy Any Domain ? << Click Here >> for more details...
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
Where the applications and where
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How are models actually derived?
Explain what is batch and describe about types of batches?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What is data warehouse architecture?
Difference between e-r modeling and dimentional modeling?
I need a good brd and uc template?
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain why are oltp database designs not generally a good idea for a data warehouse?
What is the difference between filter and lookup transformation?
What are the differences between star and snowflake schema?
What is metadata in context of a datawarehouse?
Explain what is data validation strategies for data mart validation after loading process?
How to generate the cubes in framework manager?
