Hello,
Our conplete DW is filled by SSIS and some SP.
They all do their job fine and for speed purposes we didn't define foreign keys. But now we are a bit forced to use a Documentation tool. But of course as no keys are defined quite some interesting stuff is not displayed.
I thought that defining FK's and not enforcing them would help the tool, and it does, but now the question is does this affect any speed ?