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.
No comments:
Post a Comment