Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.5.2
  3. Part 2: Version 10.5.1 - 10.5.1.1
  4. Part 3: Versions 10.5 - 10.5.0.1
  5. Part 4: Versions 10.4.1 - 10.4.1.3
  6. Part 5: Versions 10.4 - 10.4.0.2
  7. Part 6: Versions 10.2.2 - 10.2.2 HotFix 1
  8. Part 7: Version 10.2.1
  9. Part 8: Version 10.2 - 10.2 HotFix 2

What's New and Changed (10.5.2)

What's New and Changed (10.5.2)

PowerCenter Binary Functions

PowerCenter Binary Functions

Effective in version 10.2 HotFix 2, you can use the following functions for binary expressions:
  • EBCDIC_ISO88591. Converts a binary value encoded in EBCDIC to a string value encoded in ISO-8859-1.
  • BINARY_COMPARE. Compares two binary values and returns TRUE (1) if they are the same and FALSE (0) if they are different.
  • BINARY_CONCAT. Concatenates two or more binary values together and returns the concatenated value.
  • BINARY_LENGTH. Returns the length of a binary value.
  • BINARY_SECTION. Returns a portion of a binary value.
  • DEC_HEX. Decodes a hex encoded value and returns a binary value with the binary representation of the data.
  • ENC_HEX. Encodes binary data to string data using hexadecimal encoding.
  • SHA256. Calculates the SHA-256 digest of the input value.
For more information about the custom functions, see the
Informatica PowerCenter 10.2 HotFix 2 Transformation Language Reference
.

0 COMMENTS

We’d like to hear from you!