Informatica Connector Toolkit Getting Started Guide

10.2 HotFix 2
- 10.4.0
- 10.2.2
- 10.2 HotFix 1
- 10.2
- 10.1.1 HotFix 2
- 10.1.1 HotFix 1
- 10.1.1
- 10.1
- 10.0

Back Next

Step 3. Define the Adapter Type System

Define the type system to specify the datatypes supported by the data source and how they map to the datatypes supported by the Informatica platform.

In the

Connector Navigator

view, right-click the project and select Define Typesystem.

The

Define Type System

dialog box appears.

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

Manually Create Type System

The

Define Type System

dialog box appears.

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

Native to Platform Type

Click

Add

to configure each type system attribute.

The

Add Type

dialog box appears.

Enter the following values for the Timestamp attribute:

Property	Value
Type Name	Timestamp
Comments	Stores a period of time in years, months, days, hours, minutes, and seconds.
Platform Type	Date
Max Scale	6
Default Scale	6
Supported Units	Year, Month, Day, Hour, Minute, and Second.

To map the Informatica Platform DATE data type to the MySQL data type Timestamp as one of the Best Native Type to Write, select Mapped in the DATE row and then select Best Native Type to Write.

Enter the following values for the Double attribute:

Property	Value
Type Name	Double
Comments	A double-precision, floating-point number that is accurate to approximately 15 decimal places. Permissible values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308.
Platform Type	Double
Max Precision	15
Default Precision	15
Precision Radix	Decimal
Max Exponent	11
Min Exponent	0
Exponent Radix	Binary

To map the Informatica Platform Double data type to the MySQL data type Double as one of the Best Native Type to Write, select Mapped in the Double row and then select Best Native Type to Write.

Enter the following values for the String attribute:

Property	Value
Type Name	String
Comments	Variable-sized field of characters.
Platform Type	string
Max Length	8000
Default Length	50
Length Unit	characters
Restrictions	Allow Length Modifications and Allow Variable Allocation.

To map the Informatica Platform string type to the MySQL data type String as one of the Best Native Type to read, select Mapped in the String row and then select Best Native Type to Read.

Click

Generate Code

Creating an Adapter