Monthly Archives: August 2013

Profile Multi-Set Select Statements

At times we need to select from two or more sources and stage the selected source.  As an example, you may want to collect all historical records from an archive on the initial load, and collect only new records from

Build a Data Mart in 15 Minutes

Watch this short video to learn how LeapFrogBI is transforming traditional data warehouse development into a fast and flexible process.

TDWI Conference – Agile Data Warehousing 101

I’m happy to be attending the TDWI Agile BI conference in San Diego this week. Today, Sunday, kicks off a series of great learning sessions. I chose to start the conference by attending Ralph Hughes’s Agile DW 101 all day

Introducing Pattern Based Development

Building a data mart often follows the 80/20 rule. 80% of development follows a standard design pattern. The remaining 20% requires custom logic to be applied to the design. When following a standard design pattern, why not automate all of