Interested to Buy Any Domain ? << Click Here >> for more details...
What is a fact table?
- 1 Answers
- 1519 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are the different models used in cluster analysis?
What are the different types of segments?
Explain what are slowly changing dimensions?
Where we use surrogate key explain with example?
How are the dimension tables designed?
How does data mining and data warehousing work together?
What is ?Data mining??
if we increase the number of dimensions will the rows in fact table increase or decrease??
What are the advantages of query studio compared to report studio?
What are parallel querys and query hints?
What is the difference between Datawarehouse and OLAP?
Teradata 
