Here is a nifty way to add an IDENTITY column on the fly...

select distinct

id=IDENTITY (int, 1,1),

usr

into dim_usr

from fact_eyeballs