Technology Editor:Advanced

 
Parameters
This section includes additional parameters for the technology.

Column-Alias Separator: Element designed to separate a column from its alias in a SQL SELECT clause.
In the ISO standard, this separator is "AS", however, it is not supported by all databases and may therefore be left incomplete.

Table-Alias Separator:Element designed to separate a table from its alias in a SQL FROM clause. This element may be left incomplete.

Date Function : Function allowing the date and the time to be returned. For example, getdate() for Microsoft SQL Server or sysdate under Oracle

String Datatype Mask : The syntax used to describe Chain-type data in DDL orders (table creation). The Oracle Data Integrator tags %L (data length) and %P (data precision) can be used in the syntax description.

Date Datatype Mask : Syntax used to describe Date-type data in DDL orders (table creation).

Numerical Datatype Mask  :The syntax used to describe Numerical-type data in DDL orders (table creation). The Oracle Data Integrator tags %L (data length) and %P (data precision) can be used in the syntax description.

Longvarbinary Datatype Mask :Syntax used to describe longvarbinary-type data in DDL orders. To use like Numerical Datatype Mask.

DDL Null key word  :Word used to describe a column that can contain empty values (column known as NULLABLE).

Maximum column name length  :Maximum length of a column name in number of characters. All column names generated by Oracle Data Integrator are truncated to this size.

Maximum table name length  Maximum length of a datastore (table) name in number of characters. All table names generated by Oracle Data Integrator are truncated to this size.



Default Table Prefixes

This section includes the prefixes that are used for table names. You can define a prefix for the following tables:

1. Error Table
2. Temporary Index
3. Integration Table
4. Loading Table
5. Journal Table
6. Journal View
7. Journal Trigger