- Can You Make A Fact Table That Is Wrong Please Give A Example I Have Listed A Picture Of What The Fact Table Is Use 1 (61.45 KiB) Viewed 34 times
Can you make a fact table that is wrong? Please give a example. I have listed a picture of what the fact table is. Use
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Can you make a fact table that is wrong? Please give a example. I have listed a picture of what the fact table is. Use
Can you make a fact table that is wrong? Please give aexample. I have listed a picture of what the fact tableis. Use that information to make a fact table that is wrong.
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