Fact and Dimension table
Create the Fact and Dimension table attribute and the ER data model diagram for the attributes listed below.
- TRANSACTIONPARTITIONKEY
- TRANSACTIONKEY
- DAYPARTKEY
- TRANSACTIONDATEKEY
- BUSINESSDATEKEY
- PROFITCENTERKEY
- STOREKEY
- STORESTATUSKEY
- ORGANIZATIONKEY
- PERIODICORGANIZATIONKEY
- REGISTERKEY
- PTXGUID
- CHARGES
- DEBIT
- DISCOUNTS
- TAXES
- REMITTANCE
- GUESTCOUNT
- DRAWERKEY
- DEBITAMT
- REFUNDAMT
- SSSCOUNT
- STORESTATUS2KEY
- PROFITCENTERKEY_ORIG
- CATERINGKEY
- MISCCHARGES
- CREATEDTIME