http://www.sqlservercentral.com/Articles tagged Data Warehousing posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This article describes how to use variables in SSIS to dynamically generate folders and file placement.http://www.sqlservercentral.com/articles/SSIS/63152/2008/06/17http://www.sqlservercentral.com/articles/SSIS/63152/This article describes what the dimension manager and fact provider do, and how to configure business intelligence tools to use the integrated EDW.http://www.sqlservercentral.com/redirect/articles/63017/2008/05/14http://www.sqlservercentral.com/redirect/articles/63017/This article provides guidance to what an integrated EDW is and what design elements are needed to achieve integration.http://www.sqlservercentral.com/redirect/articles/63016/2008/05/13http://www.sqlservercentral.com/redirect/articles/63016/Part two of the interview looks at some design decisions in building a warehouse as well as some of the tools available.http://www.sqlservercentral.com/articles/Data+Warehousing/62510/2008/03/27http://www.sqlservercentral.com/articles/Data+Warehousing/62510/An interview with a data warehousing expert Chuck Kelley with some views about the careers in data warehousing.http://www.sqlservercentral.com/articles/Data+Warehousing/62509/2008/03/26http://www.sqlservercentral.com/articles/Data+Warehousing/62509/With data volumes exploding, conventional enterprise data warehouses are fast running out of headroom. Data warehouse appliances are starting to fill the gap, but the emerging category of column-oriented databases may offer a better option. The key to success is matching your application to the right product. http://www.sqlservercentral.com/redirect/articles/62550/2008/03/25http://www.sqlservercentral.com/redirect/articles/62550/Are you frustrated by the inefficiency, rigidity and latency of a first-generation, hub-and-spoke-architecture data warehouse? Here's a six-step guide to evolving to a streamlined, robust Kimball Dimensional Bus Architecture that will reduce time to reporting, lower data latency, and deliver more detailed, analytically useful information.http://www.sqlservercentral.com/redirect/articles/62549/2008/03/19http://www.sqlservercentral.com/redirect/articles/62549/Building a data warehouse usually isn't a small project, but somehow management sometimes sees it as something that can quickly eb done with a tool or two. Longtime DBA Janet Wong brings us a look at some of the problems you might face when getting ready to embark on this type of project. http://www.sqlservercentral.com/articles/Design/2832/2008/01/29http://www.sqlservercentral.com/articles/Design/2832/Information governance is defined by Larry English as the act or process of leading, directing, controlling and assuring that information is managed effectively as an enterprise resource. (PDF download)http://www.sqlservercentral.com/redirect/articles/61865/2008/01/23http://www.sqlservercentral.com/redirect/articles/61865/Usually a data warehouse is used for some sort of Business Intelligence system. Data warehousing experts Vincent Rainardi and Amar Gaddam bring us another great article on warehousing with a look at how a warehouse might be used for a CRM system. http://www.sqlservercentral.com/articles/Design/2823/2008/01/21http://www.sqlservercentral.com/articles/Design/2823/When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS. http://www.sqlservercentral.com/articles/DTS/2781/2007/12/31http://www.sqlservercentral.com/articles/DTS/2781/How do you cope with an executive's request to "bring back a time series of activity for all subscribers who were in platinum status as of X date," or "show me a time series of orders by sales region according to the sales organization as of Y"? Here's how data warehouse pros can cope with the common requirement to look back in time.http://www.sqlservercentral.com/redirect/articles/61738/2007/12/26http://www.sqlservercentral.com/redirect/articles/61738/This article provides an architecture and process framework for implementing common reference data in a data-warehousing environment.http://www.sqlservercentral.com/redirect/articles/61558/2007/12/04http://www.sqlservercentral.com/redirect/articles/61558/ETL processing, generally involves copying/moving, transforming, cleaning the records/transactions from one or multiple sources. Most of the batch processing or warehousing projects involve such data processing in millions on daily/weekly basis. Typically, there is a Staging area and production area. Records are cleaned, transformed, filtered and verified from staging to production area. This demands SQL Set theory based queries, parallel processing with multiple processors/CPU. The article focuses on need of SQL Set theory approach and parallel processing while processing large volume of ETL records using programming approach. http://www.sqlservercentral.com/articles/ETL/61480/2007/11/08http://www.sqlservercentral.com/articles/ETL/61480/These 34 subsystems cover the crucial extract, transform and load architecture components required in almost every dimensional data warehouse environment. Understanding the breadth of requirements is the first step to putting an effective architecture in place.http://www.sqlservercentral.com/redirect/articles/61413/2007/11/01http://www.sqlservercentral.com/redirect/articles/61413/My online series of articles has been focused on the need for businesses to "get serious" about their approach to developing an enterprise business intelligence (BI) and data warehousing (DW) capability. When pursuing this capability it is important to adopt a holistic view, followed by disciplined investment and execution.http://www.sqlservercentral.com/redirect/articles/61381/2007/10/26http://www.sqlservercentral.com/redirect/articles/61381/Part 3 of this survey looks at large data volumes.http://www.sqlservercentral.com/redirect/articles/61267/2007/10/17http://www.sqlservercentral.com/redirect/articles/61267/Part 2 of this survey looks at single views of the business.http://www.sqlservercentral.com/redirect/articles/61266/2007/10/16http://www.sqlservercentral.com/redirect/articles/61266/The IBM Data Warehousing Satisfaction Survey (2007) consisted of an invitation to some 200 end-user enterprises to participate in an anonymous, Web-based survey about data warehousing architecture, latency, size and related business issues. Invitations were sent to enterprises regardless of the data warehousing platforms they were using, and respondents included the complete spectrum of what is in the market at this time, including IBM, Microsoft, Netezza, Oracle and Teradata platforms. The emphasis was on surfacing trends that apply regardless of the specific data warehousing platform. Here is a look at some of the initial results of the survey.http://www.sqlservercentral.com/redirect/articles/61265/2007/10/15http://www.sqlservercentral.com/redirect/articles/61265/A challenge is presented for data managershttp://www.sqlservercentral.com/redirect/articles/61196/2007/10/09http://www.sqlservercentral.com/redirect/articles/61196/Collaboration between IT and the business will help identify the reasonable issues versus the issues that cannot be resolved for the current release of the data warehouse. http://www.sqlservercentral.com/redirect/articles/61195/2007/10/02http://www.sqlservercentral.com/redirect/articles/61195/This article presents a strategy for testing ETL applications that perform data movement and populate data warehouses. It is useful information for the testing community as well as designers and managers charged with planning a data warehousing implementation.http://www.sqlservercentral.com/redirect/articles/3226/2007/09/21http://www.sqlservercentral.com/redirect/articles/3226/Developing an effective solution requires quality within and across all components of the BI architecture. http://www.sqlservercentral.com/redirect/articles/3225/2007/09/20http://www.sqlservercentral.com/redirect/articles/3225/Business Intelligence Architect Bill Pearson introduces the basic .Properties function, within the first of a two-part article surrounding this important member of our MDX toolsets.http://www.sqlservercentral.com/redirect/articles/3222/2007/09/14http://www.sqlservercentral.com/redirect/articles/3222/EDM solutions are a logical and often necessary complement to operational analytics.http://www.sqlservercentral.com/redirect/articles/3224/2007/09/11http://www.sqlservercentral.com/redirect/articles/3224/A primary objective of any analytic architecture is business enablement - the ability to provide business users with access to quality information that can be used to drive decision-making.http://www.sqlservercentral.com/redirect/articles/3223/2007/09/06http://www.sqlservercentral.com/redirect/articles/3223/Organizations with mature business intelligence environments can integrate fraud analytics within their current environment to take advantage of processes and architecture that are already in place. http://www.sqlservercentral.com/redirect/articles/3192/2007/09/03http://www.sqlservercentral.com/redirect/articles/3192/Smart CFOs and CIOs should consider making mobile BI available to employees as a way to improve productivity, extend BI adoption and improve operational efficiencies. http://www.sqlservercentral.com/redirect/articles/3191/2007/08/31http://www.sqlservercentral.com/redirect/articles/3191/Use IsGeneration() to support conditional logic within filter expressions. BI Architect Bill Pearson looks beyond employing IsGeneration() in calculations, and provides hand-on practice in its use within the MDX Filter() function.http://www.sqlservercentral.com/redirect/articles/3157/2007/08/17http://www.sqlservercentral.com/redirect/articles/3157/This white paper describes how to set up a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services so that you can handle a large number of concurrent queries to your Analysis Services servers.http://www.sqlservercentral.com/redirect/articles/3148/2007/08/10http://www.sqlservercentral.com/redirect/articles/3148/