How to create data warehouse
4 posters
Page 1 of 1
How to create data warehouse
I want to create data warehouse , it includes 4 types of databases (sqlserver,oracle,mysql,access) & i have already store data in these databases but how can i create datawarehouse using sql server??? plzzzz help me.......
adeelahmad- Posts : 1
Join date : 2014-08-18
Re: How to create data warehouse
Create a new database in SQL Server, call it EDW. Extract (E) all the data from your source datababases, transform (T) it to the new enterprise data model in the EDW database, and load (L) it based on user requirements. Most folks using SQL Server like to use SSIS for their ETL tool although I'm not sure how well it connects to non-Microsoft third party databases. You may find you need to hire a couple of people to help in this process. Project managers, data analysts, data modelers, ETL developers, and reporting people are a few of the more common roles. Hopefully your question didn't imply that someone expects you to do the job of five people minimum. Good luck!
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: How to create data warehouse
but how can i create datawarehouse using sql server??? ???
asadn711- Posts : 1
Join date : 2015-04-12
Re: How to create data warehouse
Buy this:
http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/microsoft-data-warehouse-dw-toolkit/
Read.
http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/microsoft-data-warehouse-dw-toolkit/
Read.

» Ebook The Data Warehouse Lifecycle Toolkit, 2nd Edition: Practical Techniques for Building Data Warehouse and Business Intelligence Systems
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» data warehouse and data warehouse system
» difference between data mart and data warehouse at logical/physical level
» Anti-aliasing time series data in a data warehouse?
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» data warehouse and data warehouse system
» difference between data mart and data warehouse at logical/physical level
» Anti-aliasing time series data in a data warehouse?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|