Note: For a CDT, CDC must be enabled at the column level in the SQL Server table. If a SQL Server table has two capture instances, then you must select the capture instance value from the drop-down list in the Properties pane. If any CDC disabled columns are mapped in a transformation, then the CDT gives an error at Runtime.
To map the SQL Server features, double-click one of the classifiers in the ClassifierMap Designer.
The FeatureMap Designer opens displaying the SQL Server features in a tabular format.
Click inside the box adjacent to the desired source feature, and draw an arrow to connect to the target feature.
For more information about the color coding of the connection arrows, refer to Interpreting the Color of the Connection Arrows.
Note: While mapping a feature, if the capture instance value at the column level is different from the selected capture instance value at the table level, an error message appears in the Alert List view.
On the Transformation menu, click Save.
Alternatively, click the Save icon (
).
To delete a connection between the source feature and the target feature, select the arrow, and press the Delete key.
Notes:
Right-click anywhere within the table in the FeatureMap Designer, and click Sort Feature Items. You can choose either Ascending, Descending, or Sort By Creation Order to sort the feature items. This enables you to locate a feature quickly when you have a large number of features in the FeatureMap Designer.
For decimal, real, float, money, and smallmoney column types, the precision value is not displayed in the FeatureMap Designer. It appears in the Properties pane and cannot be modified. The precision value is defined while designing the database.