Select a Dimension Table and Keys (Slowly Changing Dimension Wizard)
Use the Select a Dimension Table and Keys page to select a dimension table to load. Map columns from the data flow to the columns that will be loaded.
To learn more about this wizard, see Slowly Changing Dimension Transformation.
- Connection manager
Select a data connection from the list, or click New to create a data connection.
Use the Configure OLE DB Connection Manager dialog box to select an existing connection manager, or click New to create a new OLE DB connection.
- Table or View
Select a table or view from the list.
- Input Columns
Select from the list of input columns for which you may specify mapping.
- Dimension Columns
View all available dimension columns.
- Key Type
Select one of the dimension columns to be the business key. You must have one business key.