Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Appendix A: Datatype Reference
  17. Appendix B: Configure the Web Browser

Designer Guide

Designer Guide

Informix and Transformation Datatypes

Informix and Transformation Datatypes

The following table compares Informix datatypes to the transformation datatypes that display in the Source Qualifier, Lookup, and Stored Procedure transformations. You can change the transformation datatype within the mapping, and the Integration Service converts the data. However, the datatype in the Source Qualifier, Lookup, and Stored Procedure transformations must match the source datatype. If they do not match, the mapping is invalid.
Only the Informix Text datatype appears as the transformation Text datatype in Source Qualifier, Lookup, and Stored Procedure transformations. However, use the transformation datatypes Text and String interchangeably.
Informix
Range
Transformation
Range
Byte
Minimum is 1 byte. No maximum size.
Binary
1 to 104,857,600 bytes
Char(L)
1 to 32,767 characters
String
1 to 104,857,600 characters
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Precision 19, scale 0
(precision to the day)
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Datetime year to fraction
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Precision 21 to 25, scale 1 to 5
(precision to the millisecond)
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Decimal(P,S)
Precision 1 to 32, scale 0 to 32
Decimal
Precision 1 to 28, scale 0 to 28
Float(P)
Precision 1 to 14
Double
Precision 15
Int8
-9,223,372,036,854,775,807 to 9,223,372,036,854,775,807
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
Integer
-2,147,483,647 to 2,147,483,647
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Money(P,S)
Precision 1 to 32, scale is 2
Decimal
Precision 1 to 28, scale 0 to 28
Nvarchar
1 to 255 characters
Nstring
1 to 104,857,600 characters
Serial(L)
-2,147,483,647 to 2,147,483,647
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Smallfloat
Precision 1 to 7, scale 0
Real
Precision 7, scale 0
Smallint
-32,767 to 32,767
Small Integer
Precision 5, scale 0
Text
Maximum length is 2e31
Text
1 to 104,857,600 characters
Varchar(M,R)
1 to 255 characters
String
1 to 104,857,600 characters

0 COMMENTS

We’d like to hear from you!