Hi gerry,

>>1. End - users, doing ad-hoc reports.
>
>One could argue that it is generally inadvisable to let Users loose on the (transaction optimized) "production" system; a data mart, data warehouse, etc. that draws from the production system and has been structured to facilitate end-user reporting may be preferable.

Agreed, but what does this have to do with the choice for surrogates vs natual keys ? You mean to say that the data mart should not countain surrogates ?

Walter,