Dear Nick,

I have already done the first step. so, what's in my dimension tabls have both the source keys and new surrogate keys.

the schema posted is not my Datawarehouse but it may well be something similiar.

I have thought about my measures and it is at the lowest level of granularit as well.

It is just the uploading that is posing a problem at present.