Question
In a star schema, what is the main advantage of using
surrogate keys in fact tables?Solution
Surrogate keys are artificial keys used in dimensions to avoid natural key duplication, speed joins, and handle SCDs cleanly.
More Data Warehousing Questions
- Which letter and number cluster will replace the question mark (?) to complete the given series?
LT6, KU12, IW24, FZ48, ____ - A series is given with one term missing. Choose the correct alternatives from the given ones that will complete the series.
57, 59, 56, 61, 54, ___ - Which letter-cluster will replace the question mark (?) in the following series?
RGV, UME, ?, AYW, DEF - Select the number from among the given options that can replace the question mark (?) in the following series.
17, 18, 22, 31, 47, ___ - Which letter-cluster will replace the question mark (?) in the following series?
NPQR, OORQ, PNSP, ____, RLUN
