Archives - Page 16 of 17

Why You Need A Persistent Staging Area (PSA)

Data warehousing closely resembles life in general. Just about when we feel like everything is going our way something unexpected happens. Before we know it

Working with Filegroups Just Got Easier

It is often important to custom design SQL Server database filegroups and files to meet business needs. LeapFrogBI enables developers to designate the filegroup name

SSIS Package Execution Precedence

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

Modify Lineage Quickly Using “Redirect Source”

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

Deploying Component Modifications

LeapFrogBI provides a toolset that not only streamlines initial data mart deployment, but also greatly simplifies incremental modification tasks. There are a few points that

Dimension Load Using the MERGE Statement

The T-SQL MERGE statement was introduced in SQL Server 2008, and in many ways simplified common tasks such as dimension loading. However, like most things

Schema? Prefix? Both or None?

When building SQL Server data warehouses should user-defined schemas be used? Should tables and views be prefixed? Or, maybe we should do both. After talking

Loading Dimensions From Multiple Sources

Dimensions records are often derived from multiple sources. When these sources are in sync, it is a simple enough process to combine the sources to

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

Library

Why You Need A Persistent Staging Area (PSA)

Working with Filegroups Just Got Easier

SSIS Package Execution Precedence

Modify Lineage Quickly Using “Redirect Source”

Deploying Component Modifications

Dimension Load Using the MERGE Statement

Schema? Prefix? Both or None?

Loading Dimensions From Multiple Sources

Existing Template Source SQL

Record DateTime Explained

Categories

Talk to us

Learn more

Company

Solutions

Resources