Master Data Management

Task Final Finish Where Clause

Use this page to Create a Final Finish Where Clause for a CranPort Package.

To access this page:

  1. Click Master Data Management > Design in the Navigation pane.
  2. Click the Tasks icon for a category.
  3. Click the Final Finish Tables icon for a main parent task.
  4. Click Vertical View for a table.
  5. Click the Where Clause Builder icon.

Field

Description

COLUMN NAME

Displays name of column, usually the key, being filtered on when the table is downloaded from the source database during the Finish process. The column name contains the values to use for the Where clause.

DATA SOURCE ID

Displays name of the database that contains the table or view where the Mapped Value is located.

TABLE VIEW NAME

Displays name of the table or view that contains the Mapped Value.

This table or view must already exist in the data source.

MAPPED VALUE

Displays mapped value column from the table or view name. When the Finish process runs, all values are selected from the mapped value binding on RequestID, and an IN statement is formed for selection from the source to the target database.

BEGINNING QUALIFIER

Displays character placed around the values downloaded during the finish process; default value is a single quote.

ENDING QUALIFIER

Displays character placed around the values downloaded during the finish process; default value is a single quote.

SEPARATOR

Displays character used for data values downloaded during the finish process; default value is a comma.

WHERE STATEMENT

Displays format of the where clause; default value is #ColumnName# IN (#Data#). #ColumnName# is the name of the column and #Data# is the list of values separated by the character in the Separator field.