Training
Module
Populate slowly changing dimensions in Azure Synapse Analytics pipelines - Training
Populate slowly changing dimensions in Azure Synapse Analytics pipelines
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
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.
Configure Outputs Using the Slowly Changing Dimension Wizard