The strategy is to leave the text value (account number) in the dimension table for use in display (if you need it!) and then use the AutoNumber function to generate a numeric value—also called a surrogate key—to associate the two tables.
Galina Ershovaalıntı yaptı5 yıl önce
Reducing the number of dimension table rows rarely produces a significant performance improvement.