Author: Paul B. Felix

Accumulated Snapshot Fact Table

Breakdown of an Accumulated Snapshot Fact Table When creating a model to describe a process that has a clear beginning, end, and phases in between,

SSIS Package Execution Precedence

SQL Server Integration Services offers developers a powerful toolset capable of performing a wide range of integration tasks. Data mart developers will typically design numerous

Deploying Component Modifications

The LeapFrogBI platform provides a toolset that not only streamlines initial data mart deployment, but also greatly simplifies incremental modification tasks.  There are a few

Schema? Prefix? Both or None?

When building SQL Server data warehouses should user-defined schemas be used?  Should tables and views be prefixed? Or, maybe we should do both.  After talking

Existing Template Source SQL

The LeapFrogBI DWA platform enables the use of existing tables and views.  For example, when extending a data mart there will be existing dimensions that