Compresses data using the zlib compression algorithm. The zlib compression algorithm is compatible with WinZip. Use the COMPRESS function before you send large amounts of data over a wide area network.
Syntax
COMPRESS( value )
Argument
Required/
Optional
Description
value
Required
String datatype. Data that you want to compress.
Return Value
Compressed binary value of the input value.
NULL if the input is a null value.
Example
Your organization has an online order service. You want to send customer order data over a wide area network. The source contains a row that is 10 MB. You can compress the data in this row using COMPRESS. When you compress the data, you decrease the amount of data Data Integration writes over the network. As a result, you may improve task performance.