I am trying to setup a data warehouse in our organization. We need to bring data from Finance, Payroll and HR systems into the data warehouse.
Still, we are in the process of getting the required server and software for this. My plan is to bring the data using SSIS into the new server. What I would like to know is, which option from the following is better. What are the Pros and Cons.
1. Use one database to store information from all systems.
2. Create a separate database for each system
Any help is greatly appreciated. Apologies if this is the wrong forum for this question.