What is a fact table? Explain how many fact tables are there is a star schema?

Fact tables contain information about measurements, facts, and metrics of business processes. Usually, it sits in the center of a star schema, it is also known as a snowflake schema. Usually, a fact table consists of two types of columns:

• Fact data
• Foreign key relations

Only one of these fact tables is stored in the star schema or snowflake schema. So, multiple fact tables are stored under the fact constellation schema.