An unconnected lookup can return multiple rows while a connected lookup may return
only one

Both connected and unconnected lookups can return multiple rows

An unconnected lookup may return only one value while a connected lookup may return multiple rows

Both connected and unconnected lookups can return only one row

Both input groups must have matching ports. The precision, datatype, and scale must
be identical across both input groups.

Either input group can have a port that does not match the other input group. The
precision, datatype, and scale does not have to be identical across both input groups.

When merging the 2 groups of data together, the Union transformation will remove
duplicate rows.

The port names in each input group can be named the same

The user connects directly and immediately to the Repository Service

The user connects to the service manager of the gateway node, and after authentication
and authorization, is re- Assigned to the Repository Service

The user connects to the service manager of the worker node that is running the
Repository Service, is then authenticated, authorized, and connected to the PowerCenter
Repository Service

The user first connects to the PowerCenter Integration Service and then after
authentication and authorization, is connected to the PowerCenter Repository Service

You can place an aggregate function in a variable port

You can add a filter condition to calculate values for specific rows In the selected ports

You can use operators to perform arithmetic within the function

You can calculate a single value for all rows in a group

STATE

 'CA'

NULL

 Value of the PREVI0US_STATE port is based upon its declared default value

When the setting for lookup policy on multiple match is Use Any Value

 A lookup cannot be an active transformation

When the lookup is configured to return multiple rows

 A lookup is always active

DELETE

GET

POST

PUT

Assign the minimum value of the twoto $$Variable

Assign the maximum value of the two to $$Variable

Allows the assignment of a value to a parameter

Assign the value to $$Variable, unless the value is null