Introduction Your project has a single dimension data flow defined. Now it’s time to complete an iterative deployment and load our target dimension. Success is only minutes away!
Posts by Paul B. Felix:
IntroductionSo far we’ve setup a project and created a stage component. Now it’s time to define the rest our dimension data flow. To accomplish this at lightning speed we will solicit the help of a design pattern. Prepare to be transformed into an ETL ninja!
Introduction Your project is setup. Now it is time to begin building a dimension data flow, and the first step in our data flow is a stage processes. In this video, we will create a process which will collect data from a sample CRM data source, move the data to our destination environment, and load […]
Introduction Welcome to the Getting Started video series. In this short series, we you are going to become familiar with the LeapFrogBI Platform as we step through the process of creating a single dimension data flow. In this first video, we will start by setting up a project.
The field [dbo].[Precedence].[JobNotify] in theÂ LeapFrogBIÂ console databaseÂ is used by the poll job to determine which email to send and when to send it.Â The package named â€œBI_Nofity.dtsxâ€ (step 2 of the poll agent job) consumes and sets these values.Â Here’s what the values represent.
Dimensional modeling (DM) places and emphasis on the end user’s experience. The goal is to create a data model that performs well and is simple to query. In many cases a star schema does a great job of accomplishing these goals. However, there are plenty of situations where a single fact table with direct relationships […]
Mauris sit natoque dolor condimentum himenaeos curabitur imperdiet fringilla, mollis platea consequat consectetur. Risus sapien hac tristique. Praesent magnis cursus proin etiam condimentum hac. Viverra praesent, ad proin lorem est class blandit id maecenas felis. Metus dictum interdum parturient viverra magnis curae; id potenti tellus. Tempor massa ullamcorper est turpis molestie penatibus dictumst dui nam. […]
Under Construction… We are in the process of publishing our roadmap. For now, below is a list of the most commonly requested features. Got a request? Send it to email@example.com. We keep track of all requests, and we do our best to get them added to a upcoming release.
What is a dimensional model? What is a data warehouse? This video introduces dimensional modeling while setting the stage for the series of dimensional modeling training videos to follow.
Components are typically unique and apply only to a particular unit of work. The component’s source contains a unique set of outputs and the component exposes a transformed set of output. However, there are some cases where a component can be applied to numerous data flows with only minor differences. Consider a data warehousing effort […]
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 […]