Explain the Fact and Dimension table with an example?
Sigiloso
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