Question

Adeel Ahmad Mughal on Mon, 18 Aug 2014 07:28:16


  • I want to create data warehouse "Electricity" , 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.......


Sponsored



Replies

Olaf Helper on Mon, 18 Aug 2014 08:09:31


Hello,

a "Data warehouse" is mainly a normal relational database; you can create it like every other database.

You can then use SSIS = Integration Services to load the data from your other data sources.

Saeid Hasani on Mon, 18 Aug 2014 08:48:49


In addition to Olaf notes, please see these links:

Create First Data WareHouse

Creating a Data Warehouse

SSIS Novices’ Guide to Data Warehouses: Moving Data into the Data Warehouse

Visakh16 on Mon, 18 Aug 2014 09:15:38


First you need define the tables for datawarehouse. This would mostly be denormalised form and will include tables designed as per dimensional modelling ie as facts and dimensions. The data for these tables will be extracted from your source tables ie sqlserver,oracle,mysql,access. Usually there will be a staging area where you will bring data as is from sources. Then you will apply some transformation rules to convert these data to useful information ie add more calrity to data from user prespective. This is then loaded to the tables in datawarehouse. You make use of ETL tools like SSIS for doing this extract (E), transform (T) and load (L) activity. The data warehouse will usually be star schema based ie fact table related to dimension tables using reference key values.

Ahsan Kabir on Thu, 21 Aug 2014 08:45:15


"7 Steps to Data Warehousing." In this follow-up article, we’ll demonstrate more in-depth data warehousing practices by focusing on a single business process, training. Keep in mind that we can add other processes to the data warehouse. The first step is to verify that data to describe this process is available. Then we’ll choose the key performance indicators that characterize the process, and perform dimensional analysis to generate the star schema. In future articles, we’ll populate the star schema tables, create cubes from the star schema, and use front-end tools to analyze it.

ref:http://sqlmag.com/database-administration/step-step-data-warehousing