slowly changing dimensions Archives

Creating & Executing SQL Statements in IRI Workbench

by Susan Gegner

Among the many database-centric features in IRI Workbench is the ability to create, modify, and execute SQL statements manually or graphically. These “SQL scrap-booking” features are available through the free Data Tools Platform (DTP) plug-in for Eclipse, which also supports IRI job wizards for database:

profiling, searching, classification, E-R diagramming, and integrity checking integration, including ETL, pivoting, slowly changing dimensions, and change data capture column masking, including format-preserving encryption, redaction, and pseudonymization subsetting, test data generation, and bulk loading migration, replication, and offline reorgs

To use the cross-platform(!) Read More

Business Intelligence (BI)

Introduction to Slowly Changing Dimensions (SCD)

by Susan Gegner

A dimension is a structure that categorizes a collection of information so that meaningful answers to questions regarding that information may be obtained. Dimensions in data management and data warehouses contain relatively static data; however, this dimensional data can change slowly over time and at unpredictable intervals. Read More

Data Masking/Protection

Drawing Values from Set Files

by Paul Friedland

This article looks at sets from an informational processing perspective; what they are; how they are constructed; and, distinct ways in which data can be drawn from sets within IRI software products using the SortCL data definition and processing program; i.e., Read More

Business Intelligence (BI)

SCD Type 4

by Susan Gegner

Dimensional data that change slowly or unpredictably are captured in Slowly Changing Dimensions (SCD) analyses. In a data warehouse environment, a dimension table has a primary key that uniquely identifies each record and other pieces of information that are known as the dimensional data. Read More

Business Intelligence (BI)

SCD Type 6

by Susan Gegner

Business Intelligence (BI)

SCD Type 3

by Susan Gegner

Dimensional data that change slowly or unpredictably is captured in Slowly Changing Dimensions (SCD) analyses. In a data warehouse environment, a dimension table has a primary key that uniquely identifies each record and other pieces of information that are known as the dimensional data. Read More

Business Intelligence (BI)

SCD Type 2

by Susan Gegner

Business Intelligence (BI)

SCD Type 1

by Susan Gegner

Data Quality (DQ)

Working Towards Data Quality

by Paul Friedland

Introduction

In this article, I suggest ways to move your company’s data towards a higher state of quality. The highest quality occurs when the data meets the needs of your company. Read More

Tag: slowly changing dimensions