Oracle Sources in Data Synchronization Task
You can use a single, multiple related Oracle objects, or saved query in a Data Synchronization task. You can define relationships based on key columns or create a user-defined join condition. You can add multiple Oracle objects that have an explicit relationship defined in Oracle.
Note: For an Oracle source database, omit the final semicolon from the statement.
The following table describes the Oracle source properties:
Property | Description |
|---|
Connection | Name of the source connection. |
Source Type | Type of the source object. Select Single, Multiple, or Saved Query. |
Source Object | Name of the source object. |
Display source fields in alphabetical order | Displays source fields in alphabetical order instead of the order returned by the source system. |