Questions and Answers
Which process is considered unique by the business users in the procurement schema design?
Vendor payments
Which transaction type has a dimensionality difference compared to the others according to the text?
Vendor payments
What type of numbers are mentioned in the text as perfect candidates for degenerate dimensions in the procurement pipeline?
Payment check numbers
In which transaction type is the name of the employee who received goods at the warehouse relevant, according to the text?
Signup and view all the answers
Which system provides shipping notices and warehouse receipts in the procurement schema design?
Signup and view all the answers
What should be the primary consideration for dimensional modelers when deciding between a single fact table and multiple fact tables?
Signup and view all the answers
In the context of procurement transactions, why might it be more suitable to have separate fact tables for different transaction types?
Signup and view all the answers
How can the presence of separate control numbers for different steps in a business process impact the design decision of fact tables?
Signup and view all the answers
Why might the dimensionality of facts play a role in deciding between a single fact table or multiple fact tables?
Signup and view all the answers
What is a technique recommended to clarify trade-offs when deciding between a single fact table and multiple fact tables?
Signup and view all the answers