" even tho it will double the rows to load into the dim"... so? If you have a normal data warehouse, the number of rows in a dimension table is usually orders of magnitude smaller than a fact table.