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
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What is dimensional modelling?
How to generate iqd file from framework manager?
How to eliminate duplicate rows from flat file?
What is dimension modeling?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What are algorithms provided by Microsoft in SQL Server?
What is a full backup?
What are the different types of data warehouses?
I know of using applysimple, but there are other ways too?
What is cfapplication tag?
What is the difference between datawarehouse and bi?
What are the stages that are required in data warehousing?
What is metadata in context of a datawarehouse and how it is important?
What is a relationship?
