Dimension table will have primary key and most probably the text data where as fact table will have foreign key and all the numerical data Example:customer sales where customer basic information is in dimension and total sales profits numerical calculation will be in fact table