問題文
A logistics team must decide between SCD Type 1 and Type 2 for a carrier dimension. The business needs historical accuracy, but the platform team is concerned about the dimension growing and every downstream join needing an effective-period condition. How should they frame the decision?
選択肢
- Historical accuracy is a business requirement, so Type 2 is required; the growth and join complexity are the costs to manage, for example by limiting which columns trigger a new version.
- Use Type 2 but delete versions older than 90 days, which keeps the dimension small and limits how many effective periods each join has to consider.
- Neither is needed; the change data feed on a Type 1 dimension provides the history.
- Type 1 is preferable because the growth and join complexity of Type 2 outweigh the business requirement, and the effective-period condition would have to be added to every downstream join.