dimension tables: Nothing but Master tables. In short: The table which is having Master data will be dimension table. (How we have to see the data, will be dimension table)
fact tables: Noting but Transaction tables. In short: The table which is having transaction data will be fact table.(What data we have to show, will be fact table)
