Introduction

The catalog dimension is intended for those fact tables and star schemas that need to capture performance measurements in the sales domain.

Description

The catalog dimension is derived from:

  1. ProdCatalog entity

The discriminating factor is the prodCatalogId

and consists of following elements (fields):

name

alias

type

description

dimensionId
id-longthe unique identifier of the record
catalogId
idthe natural (primary) key from table 1 (see above): prodCatalogId
catalogName
description

The name of the catalog


Related tickets