5 docs tagged with "dimensional-modeling"

Drive a Biml package generator from header and detail metadata tables that describe a base SELECT and a sequence of Lookup transforms for dimensional denormalization.

Build a reusable BimlScript template that loads a Type 1 slowly changing dimension with hash key change detection and set based updates.

Define dimension and measure group metadata directly on the underlying tables, then assemble a multidimensional cube with role playing dimensions and partitions.

Build a reusable BimlScript template that loads a hybrid Type 2 (Type 6) dimension with both historical and current attributes.

Build a reusable BimlScript template that loads a Type 2 slowly changing dimension using set based updates and hash key change detection.