title: Star Schema Design / best practice
body: <p>I am working with a system, which has 4 databases:</p>
  
  <ul>
  <li>Account (Storing bank accounts, transactions, etc)</li>
  <li>Client (Client related info)</li>
  <li>Credit (getting rates from 3rd party system)</li>
  <li>Quality (Further internal calculation)</li>
  </ul>
  
  <p>I want to create 4 facts tables, one fact table for each database... for example, I will have an Account Fact table with ClientAccount, Transaction, Provider as its dimension table. I will have 3 similar Fact Tables for other databases.</p>
  
  <p>My Question is: does it make sense to include each corresponding fact table in that  database? i.e. Create Accounting Fact and Dimension tables in the Account database? Or is it a better to create a new database for all of our star schema, and include all the dimension and fact tables in their own database?</p>