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 Data Integration and load the data to a data warehouse. You can decompress each row of data using DECOMPRESS for the row. Data Integration can then load the decompressed data to the target.