I'd love to be in Hendra's position...... a datawarehouse that isnt mission critical. What a joy that would be. We have several real time cubes that make our datawarehouse mission critical, not just for the users but they feed information back to the OLTP (OK, not the best scenario I know but the decision was taken out of my hands). With that in mind FK's have proved a their worth on a couple of ocassions. I'm not overly keen on them as they do prove a bit of a pain when developing and other things but they have proved useful in our situation. On several other projects in the same datawarehouse I have elected to remove FK's because I deemed them unnecessary, so I suppose my approach is horses for courses, what works in one case might not in another.