Siebel Order Management Infrastructure Guide > PSP Engine > Row Set Transformation Toolkit Methods >

Dynamic Look-Up Method


The Dynamic Look-Up method looks up each input row in a dynamic matrix using a dynamic search expression. For example, it could be used for attribute adjustments. See Table 12 for further description.

Arguments
Table 12. Dynamic Look-Up Method Arguments
Argument
Description

Context

Optional. Property set of variables shared across all rows.

Row Set

The set of rows to process.

Output Row Set

Optional. The property set used for output.

Process Condition

A Boolean condition that is evaluated to determine whether to process each row.

Dynamic Matrix Name

The name of the dynamic matrix to query.

Cache Enabled

Optional. Whether to cache query results. Y or N. Default = N.

On First Match [1..20]

Actions to perform on the first query result for each input row.

On Match [1..20]

Actions to perform on every query result for each input row.

On Last Match [1..20]

Actions to perform on the last query result for each input row.

On No Match [1..20]

Actions to perform if there are no query results for an input row.

Example

Figure 22 shows an example of arguments for a PSP procedure step named Matrix Adjustment, which uses the Dynamic Look-Up method.

Figure 22. Example of Arguments for Dynamic Look-Up Method
Click for full size image

Siebel Order Management Infrastructure Guide Copyright © 2006, Oracle. All rights reserved.