As far as NOLOCK I always recommend caution while using it. You want to make sure that data in your DW is valid and you didn't get something in-flux.

CEWII