Using the Shared Dimension step for SDR

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-09

The Shared Dimension step works in much the same way as the Annotate Stream step, refining your data through the creation of dimensions which can be shared for later use. You will need to designate one annotation in the shared dimension step as the dimension key.

You can create multiple annotations on the same field, such as an attribute and a dimension key. For example, in the Shared Dimension step, you can select the field Year and annotate it as a dimension key. You may also select the field Year again to annotate as an attribute. You can also create multiple annotations to modify the same data model.

The transformation which builds a shared dimension should run before the Build Model job entry or in a separate job which runs before the Build Model. Here is an example transformation for a shared dimension.
Shared dimension workflow

After you are done with your data model, you will be ready to publish it.