Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Inferred Dimension Members (Slowly Changing Dimension Wizard)

Inferred Dimension Members (Slowly Changing Dimension Wizard)

 

Use the Inferred Dimension Members dialog box to specify options for using inferred members. Inferred members exist when a fact table references dimension members that are not yet loaded. When data for the inferred member is loaded, you can update the existing record rather than create a new one.

To learn more about this wizard, see Slowly Changing Dimension Transformation.

Enable inferred member support

If you choose to enable inferred members, you must select one of the two options that follow.

All columns with a change type are null

Specify whether to enter null values in all columns with a change type in the new inferred member record.

Use a Boolean column to indicate whether the current record is an inferred member

Specify whether to use an existing Boolean column to indicate whether the current record is an inferred member.

Inferred member indicator

If you have chosen to use a Boolean column to indicate inferred members as described above, select the column from the list.

Community Additions

ADD
Show:
© 2015 Microsoft