- Can You Make Fact Table That Is Wrong I Have Listed A Picture What Fact Table Is Use That Information To Make Fact Tab 1 (61.45 KiB) Viewed 39 times
Can you make fact table that is wrong? I have listed a picture what fact table is. Use that information to make fact tab
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Can you make fact table that is wrong? I have listed a picture what fact table is. Use that information to make fact tab
Can you make fact table that is wrong? I have listed a picturewhat fact table is. Use that information to make fact table that iswrong
51 Fact tables ■ A fact is "an observation in the marketplace" (Kimball et al, 1998). ■ Facts typically numeric, such as amounts, quantities, counts. ■ Each occurrence of a fact table represents an indicator of the business ■ Non-key attributes are functionally dependent on the entire (composite) key ■ Fact tables represent a many-to-many relationship between dimension tables. ■ Within a data warehouse, a query typically involves only one fact table at a time. Dr. Peter Wolcott ISQA 8410 Data Management SALESFACT PROD_KEY CHANNEL_KEY SUPPLIER_KEY PROMO_KEY TIME_KEY CUST_KEY ORDER ID OD_QTY OD_EXTPRICE 51
51 Fact tables ■ A fact is "an observation in the marketplace" (Kimball et al, 1998). ■ Facts typically numeric, such as amounts, quantities, counts. ■ Each occurrence of a fact table represents an indicator of the business ■ Non-key attributes are functionally dependent on the entire (composite) key ■ Fact tables represent a many-to-many relationship between dimension tables. ■ Within a data warehouse, a query typically involves only one fact table at a time. Dr. Peter Wolcott ISQA 8410 Data Management SALESFACT PROD_KEY CHANNEL_KEY SUPPLIER_KEY PROMO_KEY TIME_KEY CUST_KEY ORDER ID OD_QTY OD_EXTPRICE 51