Loading Dimensions From Multiple Sources
Dimensions records are often derived from multiple sources. When these sources are in sync, it is a simple enough process to combine the sources to
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.
Getting Started 1 of 4: Project Setup
New to the LeapFrogBI Platform? You are in the right place. This short video series will help you get started quickly.