A common question in SAP interviews, the star schema is an amalgam of fact tables and dimension tables. Separate tables are used to store master data and these tables have reference to characteristics in dimension tables. Exactly these separate tables are called extended star schema.