Data Mapping Properties
The Properties window allows you to access and edit the settings of a Data Mapping. To see the properties, click a Source, Target or Expression transformation in the Outline Window.
Source / Target
The following properties are available for Sources and Targets:
- General
- Column Definition
- Key Definition
- SQL Query
General
General properties allow you to see metadata information.
Category Name | Property Name | Description |
---|---|---|
Connection Information | Data Object Type | Data Object Type (i.e. Table Schema). |
Connection Information | System | System Information. |
Connection Information | Data Source | Data Source (Connection Name). |
Object Definition | Database | Database name of object. |
Object Definition | Schema | Schema name of object. |
Object Definition | Name | Name of object. |
Object Definition | Type | Type of object (i.e. Table). |
Object Definition | Description | Description of object. |
Object Format | Format | Format of object (Delimited, Fixed-Width). |
Object Format | Delimiters | Dilimiters of object. |
Object Format | Text Qualifier | Text qualifier of object (No Quotes, Single Quotes, Double Quotes). |
Column Definition
Column Definition properties allow you to see the column definition.
Key Definition
Key Definition properties allow you to see the primary and foreign key definitions.
SQL Query
SQL Query allows you to specify SQL statements.
Expression
Expression transformation allows you to specify business rules (Expression, Default Value and Format) for targets.