When creating dimensions based on fact table data, e.g. state values,
is there an advantage to creating a view first and creating the
dimension from the view? e.g. select distinct state from my_fact_table
(as a vw_distinct_states).

Or, will the dimension only consider distinct values if the dimension
is created from the fact table directly?

Thanks,
Joe