I suppose separate DBs means easier maintenance: if you were to use disk and table partitioning and separate tablespaces wouldn't the result be similar? I can see that the modular...

I agree with extensive use of foreign keys in an OLTP database (I worked on one recently which had NONE and it was a very scary experience). Personally I would...

Do you mean separate databases for the fact and dimension tables?

I am curious to know if this slows down joins between fact and dimension tables due to their being in...

Shouldn't those 5 missing zip codes be shown up by the RI in the OLTP database?

If the OLTP database lacks RI it won't exist in the DW either!

I think that...