DECOMPRESS
Decompresses data using the zlib 1.2.1 compression algorithm. Use the DECOMPRESS function on data that has been compressed with the COMPRESS function or a compression tool that uses the zlib 1.2.1 algorithm. If the session that decompresses the data uses a different data movement mode than the session that compressed the data, the output of the decompressed data may differ from the original data.
Syntax
DECOMPRESS( value, precision )
The following table describes the arguments for this command:
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 PowerCenter and load the data to a data warehouse. You can decompress each row of data using DECOMPRESS for the row. The Data Integration Service can then load the decompressed data to the target.