SourceColumn

The SourceColumn (SC) parameter lets you specify a column name in the source table that differs from the column name in the target table. Specifying the SourceColumn parameter with a corresponding TargetColumn parameter defines how the High-speed Apply Engine maps column names. You can specify this parameter as many times as necessary to map the columns for the table named in the SourceTable parameter.

Related topic

ObjectMap-parameters

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[ObjectMap]

Abbreviation

SC

Required?

No

Valid values

A valid column name from the source table

Default value

None

Usage

If you specify SourceColumn, the corresponding TargetColumn parameter must immediately follow it. You can include wildcard characters as part of the column name. For more information about using wildcard characters in object-name mapping, see Using-wildcards-to-map-object-names.

This parameter is not valid if your input contains data definition language (DDL) statements in SQL input (or DDL objects in logical log input).

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*