What is the surrogate key rule for the star schema, and what are the main reasons for this rule?
What will be an ideal response?
Each and every key used to join the fact table with a dimension table should be a surrogate key (meaning system-assigned) and not a key which uses a business value. The reasons that a surrogate key is required are the following:
1. Slowly, over time, business keys change. A surrogate key allows us to handle changing business keys easily.
2. Surrogate keys are shorter and simpler.
3. Surrogate keys can be the same length and format, regardless of the business dimension.
You might also like to view...
In new product buying, the users are often the ________
A) monitors B) influencers C) gatekeepers D) deciders E) primary advertisers
A manufacturing firm uses a level utilization production-planning horizon of three months. They have developed a forecast for the coming three quarters that appears in the table
They can add no more than 10% of their production capacity as overtime and can order no more than 10% of a month's regular capacity via subcontractors. The company has a zero backorder policy but has space for a maximum of 100 items in their finished-goods inventory. If all extra costs are shown in the table, what is the minimum cost sales and operations plan? January February March Forecasted Demand 1100 950 1350 Regular Capacity 1000 1000 1000 Workforce level Overtime ($40/unit) Subcontracting ($100/unit) Inventory holding ($10/unit) Total Cost