Fact table: It contains numeric values and also contain 
composite key(i.e collection of foreign key) e.g.. sales 
and profit.
Dimension table: It contains character values E.g 
Customer_name,Customer_city.

A fact table typically has two types of columns: those that 
contain facts and those that are foreign keys to dimension 
tables. facts may be composed of measures,degenerated 
dimensions.The primary key of a fact table is usually a 
composite key that is made up of all of its foreign keys

Dimension tables, also known as lookup or reference tables, 
contain the relatively static data in the warehouse. 
Dimension tables store the information you normally use to 
contain queries. Dimension tables are usually textual and 
descriptive and you can use them as the row headers of the 
result set. Examples are customers or products