Mastering QlikView

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.

Reducing the number of dimension table rows rarely produces a significant performance improvement.