In the

Connector Navigator

view, right-click the project and select

Define Typesystem

.

To manually define a type system that matches the data types in the data source, select

Manually Create Type System

.

To map the native data types to the Informatica platform data types, select

Native to Platform Type

.

To map the native data types to the Java data types, select

Native to Java Type

.

Click

Add

to configure each type system attribute.

Enter the following properties for the type system attribute:

Property	Value
Type Name	Name for the native type system attribute.
Comments	Comments for the native type system attribute.
Best Platform Type for Read/ Best Java Type for Read	The platform or Java data type that maps best to the native data type when the adapter reads from the data source.
Properties	Based on the selected best platform or Java type for read, you must set one or more of the following native type properties: Precision properties such as max precision and default precision. Scale properties such as max scale, default scale, and min scale. Length properties such as max length and default length. The maximum length of any attribute cannot be greater than Integer.MAX_VALUE, which is 2,147,483,647. Unit of length such as characters, bytes, and bits. Date properties such as hour, minute, second, year, month, day, and time zone.

If the platform data type or Java data type is the best match when writing to the native data type, select

Mapped

and then select

Best Native Type to Write

. For example, to map the Java INTEGER data type to the MySQL data type INT as one of the Best Native Type to Write, select Mapped in the INTEGER row and then select Best Native Type to Write.

If you want to map a platform data type or Java data type to the native data type but not as a best match, select only

Mapped

. For example, if the Java SHORT data type maps to the MySQL data type INT but might result in loss of data when converted, select Mapped in the INTEGER row.

Click

OK

. The

Define Type System

dialog box appears.

After you add and map the required native data types for the adapter, click

Generate Code

.