- Give An Example Of A Corrected Fact Table S Please Dont Copy Answer From Before Give Another Example Of Another Fact 1 (61.45 KiB) Viewed 53 times
give an example of a corrected fact table(s). PLEASE DONT COPY ANSWER FROM BEFORE. GIVE ANOTHER EXAMPLE OF ANOTHER FACT
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
give an example of a corrected fact table(s). PLEASE DONT COPY ANSWER FROM BEFORE. GIVE ANOTHER EXAMPLE OF ANOTHER FACT
give an example of a corrected fact table(s). PLEASE DONT COPYANSWER FROM BEFORE. GIVE ANOTHER EXAMPLE OF ANOTHER FACT TABLE
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