Give the two types of tables involved in producing a star schema and the type of data they hold.
Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.
Explore posts in the same categories: Data WareHousing Interview Questions, Database Interview Questions, Oracle Interview Questions