The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an Oracle source and an Open Table target:
Oracle Source Data Type
Open Table Target Data Type
CHAR
string
VARCHAR2
string
NCHAR
string
NVARCHAR2
string
NUMBER
decimal(38, 0)
NUMBER(*,s)
decimal(38, s)
NUMBER(p,s)
decimal(p, s) (p<=38, s<=p)
FLOAT
string
INTEGER
decimal(38, 0)
BINARY_FLOAT
double
BINARY_DOUBLE
double
DATE
timestamp
ROWID
string
RAW
binary
TIMESTAMP(p)
timestamp
Note: If necessary, you can create custom data-type mappings when you define a database ingestion and replication task. For more information, see "Data Type Rules" in Configure an Open Table target.