Excel Security – Interactive User Identity
Several LeapFrogBI processes use Excel to define configuration details such as FTP, HTTP, and MFS. In some versions of windows, the Excel application is set
SQL Server 2014 Has Arrived!
Like many of you I have been waiting for SQL Server 2014 to be released to market for quite a while. Now that it has
Turn On Snapshot Rollbacks in 5 Seconds
Have you ever had the need to rollback your project to a point prior to the last load process? Well, it is easier than ever
New Design Patterns – PSA Soft Delete
Two new design patterns are now available. These design patterns, DP-4100 & DP-4101, generate all required components and related logic to track source system deletes
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