Database - Define Fact tables and dimension tables

Define Fact tables and dimension tables.

Fact tables are central tables in data warehousing. They contain the aggregate values that are used in business process. Dimension tables describe the attributes of the fact table.

Define Fact tables and dimension tables.

Fact Tables: These tables track a specific activity. These are the schema for star schema.

For example :
The changes of email messages are tracked while processing by the contact center, is tracked by fact table requestEvent. The email messages are tracked through contact center by the fact table queueEvent.

Dimension Table: These tables are the end of the stars and contain the entity attributes. For example, one record for one customer is available in the customer dimension which interacted with the contact center and the every information is known to the customer.
Database - Explain the ETL process in Data warehousing
Extraction, Transformation and loading are different stages in data warehousing. ......
Database - What is Data mining?
Data mining is a process of analyzing current data and summarizing the information in more useful manner.....
Database - What are indexes?
Indexes can be clustered and non-clustered indexes. Clustered index keeps all the records in the database in the order of clustered index key......
Post your comment