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. Datatype Reference
  17. Configure the Web Browser

Port-to-Port Data Conversion

Port-to-Port Data Conversion

The Integration Service converts data based on the datatype of the port. Each time data passes through a port, the Integration Service looks at the datatype assigned to the port and converts the data if necessary.
When you pass data between ports of the same numeric datatype and the data is transferred between transformations, the Integration Service does not convert the data to the scale and precision of the port that the data is passed to. For example, you transfer data between two transformations in a mapping. If you pass data from a decimal port with a precision of 5 to a decimal port with a precision of 4, the Integration Service stores the value internally and does not truncate the data.
You can convert data by passing data between ports with different datatypes. For example, you can convert a string to a number by passing it to an Integer port.
The Integration Service performs port-to-port conversions between transformations and between the last transformation in a dataflow and a target.
The following table describes the port-to-port conversions the Integration Service performs:
Datatype
Bigint
Integer, Small Integer
Decimal
Double, Real
String, Text
Nstring, Ntext
Date/Time
Binary
Bigint
No
Yes
Yes
Yes
Yes
Yes
No
No
Integer,
Small Integer
Yes
No
Yes
Yes
Yes
Yes
No
No
Decimal
Yes
Yes
No
Yes
Yes
Yes
No
No
Double, Real
Yes
Yes
Yes
No
Yes
Yes
No
No
String, Text
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Nstring, Ntext
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Date/Time
No
No
No
No
Yes
Yes
Yes
No
Binary
No
No
No
No
No
No
No
Yes


Updated July 02, 2020