Property | Description |
|---|---|
Connection | Name of the source connection. |
Source Type | Type of the source object. Select Single Object, Multiple Objects, or Parameter. |
Object | Name of the source object for the mapping. You can specify a custom query for a source object. |
Filter | Adds conditions to filter records. Configure a simple or an advanced filter. When you configure partitioning, separate multiple filter conditions with parentheses (). |
Sort | Determines the order of the rows. Add the ORDER BY clause in the select query with the COLUMN provided. By default, the sort is in ascending order. |
Select distinct rows only | To read the unique rows from source in the select query. |
Advanced Property | Description |
|---|---|
Tracing Level | Amount of detail that appears in the log for this transformation. You can choose terse, normal, verbose initialization, or verbose data. Default is normal. |
Pre SQL | One or more SQL statements that are executed before the session runs.. |
Post SQL | One or more SQL statements that are executed after the session runs. |
Output is deterministic | Relational source or transformation output that does not change between session runs when the input data is consistent between runs. When you configure this property, the Data Integration Service does not stage source data for recovery if transformations in the pipeline always produce repeatable data. |
Output is repeatable | Relational source or transformation output that is in the same order between session runs when the order of the input data is consistent. When output is deterministic and output is repeatable, the Data Integration Service does not stage source data for recovery. |