A resilient ETL process deals with data quality issues without causing a process failure while also meeting business requirements. One issue that should be anticipated is the early arriving fact (aka late arriving dimension) situation. As the name implies an early arriving fact is a record that is bound for a fact table which references […]
When using several of the LeapFrogBI component types, configuration information is stored in Excel. This architecture is used in cases where it is not feasible to upload or input data into a web browser efficiently. Examples include; multi file stage, and rest API collection. Excel workbooks include the option to automatically “Calculate Workbook” when the […]
Users can now view a visual representation of functional constraints via the Precedence Graph option.
Metadata has the power to make or break a data warehouse. Like most innovation, a metadata driven approach to data warehousing solves common challenges by taking the process to a higher level.
You select the grain (Year, Quarter, Month, Day, Hour, Minute), the start and end date, and whether or not to use a smart key as the surrogate. You can even use relative dates to help with situations where you want to grow the dimension on each execution. Finally, the LeapFrogBI d3000 template includes a set […]
We have all seen the job postings. “Immediate hire… ETL developer with 10 years’ experience.” Regardless of fast changing technologies there will be a need for data integration for the foreseeable future. Even the largest of big data repositories can’t automatically integrate data; not yet. Having all of your data in a repository that is […]
Some of the most challenging data warehousing situations come in the form of external data mashups. Because the term “data mashup” has taken on a number of meanings over the past few years, I’ll clarify how the term is used in this post. External Data Mashup Source Data Description Systems of record are not in […]
The LeapFrogBI platform is constantly being improved thanks largely to user feedback. Here’s a quick recap of the top 10 enhancements of 2014 that you don’t want to miss! Faster Builds You will soon notice that your builds are completing much faster? LeapFrogBI hardware was upgraded on May 2nd to support rising demand while offering […]
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 to do so with the Snapshot Rollback feature. Turn the feature on, and always know that you can roll the project back to the exact state that existed prior to […]
LeapFrogBI streamlines the creation, maintenance and sharing of a data dictionary. Simply provide a text description for components and fields online, and the rest is automated! Component and field descriptions will be stored in the target database as extended properties. All extended properties will be named ”MS_Description”. This is the same name used natively when […]
SQL Server 2014 has arrived with a very nice set of new functionality. LeapFrogBI projects can now be deployed to SQL Server 2014 by simply selecting your target platform. Already have a project set to deploy to an earlier version of SQL Server? No problem. Update the target platform, queue a build, and deploy!
LeapFrogBI supports a number of physical architecture options. Developers can select an architecture and configure each project as desired. Keep in mind that LeapFrogBI creates in-database (ELT) processing whenever possible. This means the database engine will be doing the heavy lifting regardless of the location of SSIS and package execution. When selecting a target architecture strive […]