Use the Right Tool for the Job
Building a data mart can be broken down into three distinct steps. Extact data from source system Transform data to desired structure Load data into
Late Arriving Dimensions
When building a dimensional model it is critical that facts have accurate foreign keys pointing back to related dimensions. However, there are some situations where
Add Custom Scripts to Components
Users can now add custom scripts to components. For example, add indexes or update statistics using t-sql scripts. Built components will include the provided custom
Quick Review–ACID
One of the foundation concepts that all database workers should keep in the back (or maybe front) of their mind is ACID. This small and
Bulk Profile Upload
LeapFrogBI is a SaaS metadata driven ETL platform. At no time does LeapFrogBI connect directly to either the source or the destination systems. Therefore, the first
Fact Record Delete Component
The new f9001 component automates deletion of records from a fact table. Simply select the fact table to effect and a source to inner join
Stage Using REST API as Data Source
There is a wealth of data available via REST API much of which is publicly available. LeapFrogBI simplifies and automates the process of extracting data from
LeapFrogBI Success Story
I get asked on occasion to quantify the efficiency that the LeapFrogBI data warehouse automation platform offers. Below are a few measures that were collected
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.