• Since data warehouse is not a mission critical, I completely agree with Ron. Added a FK would not decrease a process at all, because we do it in a batch. No users involved in this process

    Also imagine when you had to drillthrough the data. FK will speed up the process.