Some of the int fields are loaded as YYYYMMDD so these may be good partitioning columns also but I see what you say about the indexes (looking at the dmv's it seems one index is not being used)

I am approaching the partitioning mainly from a maintenance perspective, but will also be looking at queries that may hit the table.

I'm trying to find out if there are any big pitfalls to partitioning a dimension, from a performance, load, querying perspective etc or what are the reasons to avoid doing it?