Prepare your environment and create a few stage components.
Consume data from stage components and use pattern based development to generate the remaining project data flow.
With a project definition complete we can now deploy and monitor the load process.
A series of courses including training videos and sample projects are now available in the newly launched LeapFrogBI Academy. Check back often as we add content ranging from the basics of dimensional modeling to technical deep dives. Building high quality data marts fast just got even easier! LeapFrogBI Academy Sample Project
SQL Server Integration Services offers developers a powerful toolset capable of performing a wide range of integration tasks. Data mart developers will typically design numerous SSIS packages which will create and maintain the target data mart. There are an array of options available when determining how to control the execution order of these packages. This […]
There are several ways to control the order of execution of deployed components. – Create multistep Agent jobs – Create parent packages – Deploy to msdb & query sysssispackages to get package list. Loop through packages in SSIS. – Set a configuration value for each component’s precedence in the configuration table. Use this value to […]
There are three dimension component templates; d1000, d1001, & d2000. d2000 is used when a dimension already exist & the current project needs to utilize it. The other two templates will both load a dimension while taking care of scd tracking based on user defined specifications. However, there is an important difference as described below. d1001 – Only […]