The technologies storing the formatted data allocate to each of them a type that defines their nature. For example: numerical, character, Date, etc
Some data server access drivers allow you to Reverse the datatypes automatically from the Technology window, using the Reverse button.
Property |
Description |
---|---|
Code |
Code used in Oracle Data Integrator to refer to this datatype. This code is unique for this technology. The code is stored in models and flows in order to refer to the datatype. |
Name |
Name of the datatype, as it appears in the graphic interface and the reports. |
Reversed Code |
Code returned by the driver and/or an SQL reverse query. |
Create Table Syntax |
The syntax used to create a column of this type. The tags %L (Length) and %P (Precision) can be used in this syntax. |
Writable Datatype Syntax |
This alternate syntax is used to create a column storing data for a non writable datatype. The tags %L (Length) and %P (Precision) can be used in this syntax. If the type is writable then the Writable Datatype Syntax and Create Table Syntax should be the same. |
Letter used for the icon |
The letter used to represent the datatype (Graphic id code for this datatype). |
Writable |
Check this box if this datatype can be used in an INSERT or UPDATE command. This is not the case, for example, for datatypes which values are automatically set and cannot be modified such as IDENTITY columns. Columns reversed with a datatype not writable are flagged read-only. A datatype that is not writable should have an alternate
Writable Datatype Syntax defined, to enable Oracle Data Integrator to create
temporary tables storing data of this type. |
The Converted to tab allows you to specify for the other technologies, the datatype corresponding to the current type. This datatype will be used if Oracle Data Integrator needs to create a work table on another technology that is a reflection of a datastore in the current technology.
For example:
The Oracle datatype VARCHAR2 will be transformed into VARCHAR on a Microsoft SQL Server data server.
For the data flow of an Oracle instance towards an SQL Server instance, the language generation engine may require conversion in both directions (for example from Oracle to SQL Server and from SQL Server to Oracle).
This tab shows, (read only), the other technologies' datatypes that correspond to the current datatype.