Before Development Begins…
It probably goes without saying that BI and data warehouse projects can be very complex. Taking a bottom up & agile approach breaks the larger
Multiple File Stage Made Simple
The Multi-File Stage s9600 template provides a simple method to stage many files with the same structure. The following steps describe how to setup this component.
FTP File/s Stage – s9500
The FTP File Stage s9500 template provides a simple method to collect one or more files from an FTP server. The following steps describe how to
Working With Data Sources That Do Not Track Changes
Data sources come in all shapes and sizes. Some include all of the features needed to easily integrate into load processes. Others can cause all
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,
Why You Need A Persistent Staging Area (PSA)
Data warehousing closely resembles life in general. Just about when we feel like everything is going our way something unexpected happens. Before we know it
Working with Filegroups Just Got Easier
It is often important to custom design SQL Server database filegroups and files to meet business needs. LeapFrogBI enables developers to designate the filegroup name
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
Modify Lineage Quickly Using “Redirect Source”
Part of the beauty of using the LeapFrogBI platform to define your data mart is how easy it is to make modifications. One example of
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