Data Integration Connectors
- Data Integration Connectors
- All Products
Datatype
| Supported for CDC?
| Transformation Data Type
|
---|---|---|
BFILE
| No
| Column data that has this datatype is not completely logged in the Oracle redo logs and cannot be captured.
|
BINARY_DOUBLE
| Yes
| -
|
BINARY_FLOAT
| Yes
| -
|
CHAR
| Yes
| -
|
DATE
| Yes
| The date must be in the range Jan 1, 0001 A.D. to Dec 31, 9999 A.D. in the Gregorian calendar. Dates beyond 9999 A.D. cause an error.
Also, PowerExchange does not support negative dates, such as -0001-12-20-00-00-00 . If PowerExchange receives a negative date, it substitutes an absolute value for the date and tolerates the Oracle log record that contains the date.
|
FLOAT
| Yes
| If you set the ORACLE_UNHANDLED_NUMASCHAR statement to Y in the dbmover.cfg file, PowerExchange registration processing for Oracle CDC source tables converts FLOAT columns that have a precision greater than 15 to VARCHAR columns. This setting can prevent data loss.
|
LOBs
| Yes
| Datatypes supported for Oracle LOBs are BLOB, CLOB, and NCLOB. PowerExchange can capture change data from LOB columns and non-LOB columns in the same source table, within the maximum row size limit of 8 MB.
|
LONG
| No
| Columns that have this datatype cannot be included in capture registrations.
|
LONG RAW
| No
| Columns that have this datatype cannot be included in capture registrations.
|
NCHAR
| Yes
| -
|
NUMBER
| Yes
| PowerExchange handles NUMBER columns as follows:
If you set the ORACLE_UNHANDLED_NUMASCHAR statement to Y in the dbmover.cfg file, PowerExchange registration processing for Oracle CDC source tables treats NUMBER columns that have a precision greater than 28 or an undefined length as variable length strings. This setting can prevent data loss.
|
NVARCHAR2
| Yes
| -
|
RAW
| Yes
| -
|
ROWID
| Yes
| -
|
TIMESTAMP
| Yes
| The date must be in the range Jan 1, 0001 A.D. to Dec 31, 9999 A.D. in the Gregorian calendar. Dates beyond 9999 A.D. cause an error.
Also, PowerExchange does not support negative dates, such as -0001-12-20-00-00-00 . If PowerExchange receives a negative date, it substitutes an absolute value for the date and tolerates the Oracle log record that contains the date.
|
TIMESTAMP WITH TIME ZONE
| Yes
| PowerExchange captures data with this datatype as a UTC timestamp.
The date must be in the range Jan 1, 0001 A.D. to Dec 31, 9999 A.D. in the Gregorian calendar. Dates beyond 9999 A.D. cause an error.
Also, PowerExchange does not support negative dates, such as -0001-12-20-00-00-00 . If PowerExchange receives a negative date, it substitutes an absolute value for the date and tolerates the Oracle log record that contains the date.
PowerCenter does not support this datatype. If you use PowerCenter to materialize a target table from a source table that includes this datatype, manually override the datatype in Source Analyzer with the timestamp datatype. Also, edit the generated SQL select statement that PowerCenter sends to PowerExchange to use the sys_extract_utc() function. Syntax:
|
TIMESTAMP WITH LOCAL TIME ZONE
| Yes
| PowerExchange captures data with this datatype as a UTC timestamp.
The date must be in the range Jan 1, 0001 A.D. to Dec 31, 9999 A.D. in the Gregorian calendar. Dates beyond 9999 A.D. cause an error.
Also, PowerExchange does not support negative dates, such as -0001-12-20-00-00-00 . If PowerExchange receives a negative date, it substitutes an absolute value for the date and tolerates the Oracle log record that contains the date.
PowerCenter does not support this datatype. If you use PowerCenter to materialize a target table from a source table that includes this datatype, manually override the datatype in Source Analyzer with the timestamp datatype. Also, edit the generated SQL select statement that PowerCenter sends to PowerExchange to use the sys_extract_utc() function. Syntax:
|
UROWID
| No
| -
|
User-defined types (UDTs)
| No
| -
|
VARCHAR2
| Yes
| -
|
XML types
| No
| -
|