Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / dipti a
Fact Table is the central table which has factual information. It contains numeric information and measures.
Lets say if you need to capture sales data then centrally we can have sales table(fact table) which contains numeric information and surrounding to it, we can have dimensions table like product dimensions, date dimensions, store dimensions.
So this central fact table will contacts numeric information like Prize_of_product, Qualntity and along with same we can have dimension foreign keys like product_id, store_id, date_id and so on.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the stages of datawarehousing?
Explain what are the possible data marts in retail sales?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
Explain what is a three tier data warehouse?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What are the steps to build the datawarehouse?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
How to create different types of templates?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
How to stop a batch?
What are the advantages of cold fusion?
What are modeling tools available in the market?
How to calculate fact table granularity?
