Fact Table

Fact Table | Star Schema: The centralized table in a star schema is called as FACT table. A fact table typically has two types of columns: those that contain facts and those that are foreign keys to dimension tables. The primary key of a fact table is usually a composite key that is made up…

Read More

Designing Star Schema

Star Schema: General Information In general, an organization is started to earn money by selling a product or by providing service to the product. An organization may be at one place or may have several branches. When we consider an example of an organization selling products throughout the world, the main four major dimensions are…

Read More
error: Content is protected !!