DECOMPRESS
Decompresses data using the zlib compression algorithm. The zlib compression algorithm is compatible with WinZip. Use the DECOMPRESS function when you receive data over a wide area network.
Syntax
DECOMPRESS( value, precision)
Argument | Required/ Optional | Description |
|---|
value | Required | Binary datatype. Data that you want to decompress. |
precision | Optional | Integer datatype. |
Return Value
Decompressed binary value of the input value.
NULL if the input is a null value.
Example
Your organization has an online order service. You received compressed customer order data over a wide area network. You want to read the data using Informatica Cloud and load the data to a data warehouse. You can decompress each row of data using DECOMPRESS for the row. Informatica Cloud can then load the decompressed data to the target.