Yes separate databases. All the fact data lives in separate databases as well. All these fact DBs share the common dimension db. I don't worry about joins since join speed is not related to where the data is located, it's indexes, besides almost all data access is through cubes. Integrity is an issue that is why you have proper backups. The ability to recover is what saves your job.