I'm not sure how a factless fact table would differ from a snowflake dimension in terms of the actual table structure. But even if I pursue this approach, I am left with the question: Do I relate the address to the name using the business key or with the surrogate key? And If I choose to relate with the surrogate key, what is the best way to handle the update when a new surrogate key is assigned to the same name?