What is a transaction fact tables? What is a periodic snapshot fact table? What is an accumulated snapshot fact table? This short video describes the three primary types of fact tables.
Tips & Tricks
PSA serves a vital role. However, there are also cases when we want to build something as fast as possible without worrying about a consolidation area. In this case you can create a transform that is sourced from a stage component directly. Keep in mind that PSA also serves as the place where RecordTime is […]
Monitoring a data integration process can be a time consuming task. With the new automated notification system email notifications can be sent to alert administrators of load events. A flexible configuration definition and one click deployment makes setup a cinch.
LeapFrogBI now offers project navigation via interactive graph visualizations! Simply go to any component and you will be presented with a graph representing the upstream and downstream components related to the selected components. Want more detail? No problem – check the “Extended Map” option and the graph will display all related components recursively. Still not enough? […]
One of the most important advantages to LeapFrogBI’s metadata driven data mart development platform is the ability to adjust quickly to requirement changes. It has been well established that many BI/DW projects fail due primarily to the speed at which requirements change. The traditional method of developing data marts is not flexible and often requires […]
LeapFrogBI account administrators configure project lifecycles in the project console. Each connection contains a definition for each lifecycle. After creating all of the required project components, developers deploy the project to the target lifecycle. All packages include a pointer to the lifecycle environment variable which provides connection details for the LeapFrogBI console […]
There is a wealth of data available via REST API much of which is publicly available. LeapFrogBI simplifies and automates the process of extracting data from these sources. Step 1: Create REST Stage Component s9501 will create a package which will collect REST API sourced data based on a configuration file’s definitions. Create a stage component […]
The Multi-File Stage s9600 template provides a simple method to stage many files with the same structure. The following steps describe how to setup this component. 1. Click “create new” from the stage component page. Find s9600 and download the “File”. This file is an xls file which contains the configuration details for the Multi File Stage tasks. […]
The FTP File Stage s9500 template provides a simple method to collect one or more files from an FTP server. The following steps describe how to setup this component. 1. Click “create new” from the stage component page. Find s9500 and download the “File”. This file is an xls file which contains the configuration details for the […]
Part of the beauty of using LeapFrogBI to define your data mart is how easy it is to make modifications. One example of this is the ”Redirect Source” feature. With this feature a component’s source can be changed by simply selecting the new source component and mapping new source fields to each of the old […]
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 and dimension components. RecordDateTime Definition RecordDateTime is the point in time which the record is considered effective. For example; a transaction is often considered effective at this point in time […]
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 does not have a record that meets the fk join definition. In this case LeapFrogBI will place a -1 in the FK_#### field to flag it as an unknown dimensoin […]