Difference between Fact table and Dimension table?
This is to answer the part: I was trying to understand whether dimension tables can be fact table as well or not? The short answer (INMO) is No.That is because the 2 types of tables are created for different reasons. However, from a database design perspective, a dimension table could have a parent table as … Read more