Informatica Data Quality
- Informatica Data Quality 10.4.1
- All Products
Function
| Description
| Changes
|
---|---|---|
AES_DECRYPT
| Returns decrypted data to string format.
| Supported on the Spark engine.
Previously supported only on the Blaze and Hive engines.
|
AES_ENCRYPT
| Returns data in encrypted format.
| Supported on the Spark engine.
Previously supported only on the Blaze and Hive engines.
|
COMPRESS
| Compresses data using the zlib 1.2.1 compression algorithm.
| Supported on the Spark engine.
Previously supported only on the Blaze and Hive engines.
|
CRC32
| Returns a 32-bit Cyclic Redundancy Check (CRC32) value.
| Supported on the Spark engine.
Previously supported only on the Blaze and Hive engines.
|
DECOMPRESS
| Decompresses data using the zlib 1.2.1 compression algorithm.
| Supported with restrictions on the Spark engine.
Previously supported only on the Blaze and Hive engines.
|
DEC_BASE64
| Decodes a base 64 encoded value and returns a string with the binary data representation of the data.
| Supported on the Spark engine.
Previously supported only on the Blaze and Hive engines.
|
ENC_BASE64
| Encodes data by converting binary data to string data using Multipurpose Internet Mail Extensions (MIME) encoding.
| Supported on the Spark engine.
Previously supported only on the Blaze and Hive engines.
|
MD5
| Calculates the checksum of the input value. The function uses Message-Digest algorithm 5 (MD5).
| Supported on the Spark engine.
Previously supported only on the Blaze and Hive engines.
|
UUID4
| Returns a randomly generated 16-byte binary value that complies with variant 4 of the UUID specification described in RFC 4122.
| Supported on the Spark engine without restrictions.
Previously supported on the Blaze engine without restrictions and on the Spark and Hive engines with restrictions.
|
UUID_UNPARSE
| Converts a 16-byte binary value to a 36-character string representation as specified in RFC 4122.
| Supported on the Spark engine without restrictions.
Previously supported on the Blaze engine without restrictions and on the Spark and Hive engines with restrictions.
|