PowerExchange for Amazon Redshift User Guide

10.5.7
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0

Back Next

Lookup Properties

Specify the lookup properties to look up an Amazon Redshift table. You can configure a lookup condition to look up data from the Amazon Redshift table.

There are two types of option that you must select in the

Specify by

property to configure a lookup condition:

Value

: Select this option if you want to configure a lookup condition using the column name.

Parameter

: Select this option if you want to parameterize the lookup condition.

The following table describes the lookup properties that you can specify for an Amazon Redshift lookup if you select the

Value

option:

Property	Description
Lookup Column	The name of the columns that you want to look up.
Operator	Operators that you can use to filter records. You can select one of the following operators: =, !=, <=, >=, and
Input Port	The input source port.

The following table describes the lookup properties that you can specify for an Amazon Redshift lookup if you select the

Parameter

option:

Property	Description
Parameter	The name of the parameter that you want to use to look up. You can also create a new parameter. Click New to create a new parameter. Enter the parameter name and specify an expression in the New Parameter dialog box. Click Validate to check if the expression that you specified is valid or not.

Rename Saved Search

Table of Contents

PowerExchange for Amazon Redshift User Guide

PowerExchange for Amazon Redshift User Guide

Lookup Properties

Lookup Properties