Compresses data using the zlib 1.2.1 compression algorithm. Use the COMPRESS function before you send large amounts of data over a wide area network.
The following table describes the argument for this command:
String datatype. Data that you want to compress.
Compressed binary value of the input value.
NULL if the input is a null value.
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 the
PowerCenter Integration Service
writes over the network. As a result, you may increase performance.