Design Pattern – Data Warehouse Deletes
What to do when a data warehouse source system deletes a record? There are probably hundreds of answers to this question. If you want to
Don’t Miss These Critical ETL Considerations
Anyone who has been involved with data warehousing knows that there are plenty of things that can go wrong. Mistakes can be made when researching
Faster Dimension Loads
This initial load of a dimension can be a resource intensive process. The situation gets even tougher when the dimension’s natural key is not optimal;
Selecting a Dimension Template
LeapFrogBI’s dimension templates are designed to handle a number of use cases. Below is a list of currently available templates, along with a short description
Dealing with Deletes in the Data Warehouse
Data warehousing has a clear set of objectives such as data persistence, single easy to navigate data model, fast query performance, etc… While it is
Why Dimensional Modeling?
In a requirements gathering session I was asked a question that I should have knocked out of the park. A subject matter expert asks, “Why
Interactive Graph Navigation Legend
One of the most powerful features that LeapFrogBI offers is the ability to visually describe a project in the form of an interactive graph. Users
6 Source System Data Mart Built in 2 Days
Over the past few weeks Alan & I have had the pleasure of working with a small team to build an AR data mart. The
ODBC Data Collection Made Easy
LeapFrogBI makes collecting data from an ODBC (Open Database Connectivity) data sources a simple process. Profile your source and stage your profiled data. Establish a
Collect Data via ODBC
LeapFrogBI makes collecting data from an ODBC Data Source a simple process. Profile your source and stage your profiled data. Parameterize your profile query to