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
Schema? Prefix? Both or None?
When building SQL Server data warehouses should user-defined schemas be used? Should tables and views be prefixed? Or, maybe we should do both. After talking
Existing Template Source SQL
The LeapFrogBI DWA platform enables the use of existing tables and views. For example, when extending a data mart there will be existing dimensions that
Record DateTime Explained
When creating a PSA component, the designer is asked to assign a value to RecordDateTime. The selected value will have implications downstream on both fact
Handling Failed FK Lookup
When a fact component attempts to load a record, a foreign key to a dimension lookup is performed. This lookup (join) may fail if the dimension
Aggregate to Prevent Duplicates on Fact Load
When using a merge statement to load a fact table it is important to ensure that the source component/s do not contain more than one
Getting Started 4 of 4: Deploy & Load
New to the LeapFrogBI Platform? You are in the right place. This short video series will help you get started quickly.
Getting Started 3 of 4: Dimension Data Flow
New to the LeapFrogBI Platform? You are in the right place. This short video series will help you get started quickly.
Getting Started 2 of 4: Profile & Stage
New to the LeapFrogBI Platform? You are in the right place. This short video series will help you get started quickly.