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.

Options

  • 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.

See Also

Other Resources

Configuring Outputs Using the Slowly Changing Dimension Wizard

Help and Information

Getting SQL Server 2005 Assistance