Page tree

 

NOTE: The Trifacta® data types listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

NOTE: Dots (.) in the names of Oracle tables or table columns are not supported.


Access/Read

Source Data TypeSupported

Trifacta Data Type

ANYDATAN 
ANYDATASETN 
ANYTYPEN 
BFILEN 
BINARY_DOUBLEYDecimal
BINARY_FLOATYDecimal
BLOBN 
CHARYString
CLOBYString
DATEYDate/Time
DBURITypeYString
FLOATYDecimal
HTTPURITypeYString
INTERVAL_DAY TO SECONDYString
INTERVAL_YEAR TO MONTHYString
LONG RAWYString (base64)
<media types>N 
NCHARYString
NCLOBYString
NUMBERYDecimal / Integer
NVARCHAR2YInteger
RAWYString (base64)
ROWIDN 
SDO_GEOMETRYN 
SDO_GEORASTERN 
SDO_TOPO_GEOMETRYN 
TIMESTAMPYString
TIMESTAMP WITH LOCAL TIMEZONEYString
TIMESTAMP WITH TIMEZONEYString
URITYPEYString
UROWIDN 
VARCHAR2YString
XDBUIRTypeYString
XMLTypeN 

NOTE: Implementation of Oracle custom types is a custom engagement. For more information, please contact Trifacta Customer Success Services.

 

Publish/Write

Publishing to this datastore is not supported in this release.

 

This page has no comments.