Support & Learning
Application Development and Deployment
Data Connectivity and Integration
Web Content Management
Get A Free Trial
close mobile menu
Testing & ALM
Tag: SQL Server
Building a Data Warehouse Part II: Building a new schema
[repost from Stephen Forte's Blog] In Part I: When to build your data warehouse we looked at when you should build your data warehouse and concluded that you should build it sooner rather than later to take advantage of reporting and view optimization. Today we will look at your options to build your data warehouse schema. When architecting a data warehouse, you have two basic options: build a flat “reporting” table for each operation you are performing, or build with BI/cubes in mind and implement a “star” or “snowflake” schema. Let’s take a quick look at the first option and then we will take a look at...
September 22, 2010
Building a Data Warehouse Part I: When to build your data warehouse
[repost from Stephen Forte`s Blog] Most developers are scared of “Business Intelligence” or BI. Most think that BI consists of cubes, pivot/drill down apps, and analytical decision support systems. While those are very typical outcomes of a BI effort, many people forget about the first step, the data warehouse. Typically this is what happens with a BI effort. A system is built, usually a system that deals with transactions. We call this an OLTP or on-line transaction processing system. Some time passes and reports are bolted on and some business analysts build some pivot tables from “raw dumps” of data. As the system grows, reports start to slow...
September 21, 2010
Testing & ALM
Latest updates in your inbox
Angular 5 is Here!
November 06, 2017
October 30, 2017
Telerik Platform Webinar Recap—Modernizing One Hybrid App at a Time
October 27, 2017