What's New and Changed (10.5.1.1)

Back Next

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

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.