Existing Template Source SQL
LeapFrogBI enables the use of existing tables and views. For example; when extending an data mart there will be existing dimensions that need to be
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