What is the difference between a Fact Table and a Dimension Table?

Question

Accepted Answer

Fact Table
            Dimension Table
        
        
            Stores business transactions
            Stores descriptive information
        
        
            Contains measures
            Contains attributes
        
        
            Large volume of records
            Relatively smaller
        
        
            Examples: Sales Amount, Quantity
            Examples: Product Name, Customer Name
        
    

    
        Fact tables answer "what happened" while dimension tables answer "who, when, where, and how".

Fact Table	Dimension Table
Stores business transactions	Stores descriptive information
Contains measures	Contains attributes
Large volume of records	Relatively smaller
Examples: Sales Amount, Quantity	Examples: Product Name, Customer Name

What is the difference between a Fact Table and a Dimension Table?

Answer with Explanation