This is exactly what I was looking for. The training kit specifically warns against a lookup with more than 25k records, but it's wrong and the lookup usable if...
I think you got it. I need to relate a dimension to a fact table by replacing a foreign key with a corresponding surrogate key scd2. You mentioned a lookup...