Defining the Type System Manually

1. In the Connector Navigator view, right-click the project and select Define Typesystem.
   The Define Type System dialog box appears.
2. To manually define a type system that matches the data types in the data source, select Manually Create Type System.
3. To map the native data types to the Informatica platform data types, select Native to Platform Type.
4. To map the native data types to the Java data types, select Native to Java Type.
5. Click Add to configure each type system attribute.
   The Add Type dialog box appears.
6. 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.

7. 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.
8. 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.
9. Click OK. The Define Type System dialog box appears.
10. After you add and map the required native data types for the adapter, click Generate Code.