If you need more information as to how to create a star-schema based database you can read more here This article presumes that you have already created a de-normalized data warehouse. This article gives sound advice and pointers as to how to approach the problem. It’s worth noting that there are many different ways to go about building your ETL solution. In this article we’ll take a look at the basic functionality of SQL Server Data Tools and how to use it to keep your data warehouse up to date. To do this one needs to use SQL Server Data Tools – Business Intelligence (previously known as BIDS or Business Intelligence Development Studio). The purpose of this article is to provide you with a deeper understanding into the creation of an ETL (Extract, Transform and Load) dataflow. The tools needed to build these solutions were briefly mentioned. In our previous article on the introduction to SQL Server business intelligence we covered the general structure of an enterprise business intelligence solution.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |