I am in the process of building out a data mart that consolidates data from a large number of applications where each has their own database. While I have direct access to some of the application's DBs, I pull most of the applications from a central data warehouse.
Right now we are creating separate Databases for each system, but this seems to be causing problems in locating tables and pulling tables into incorrect DBs. IE- the carSales table is in the Leasing application and in the Loan application. What DB should we bring it into Leasing, Loan, both, or a 3rd option?
I am not highly confident in this schema, and looking for documentation on how to either make it work, enhance it, or documentation on why this schema should be scrapped.