Data Steward Guide

10.3

Back Next

Using the Search Wizard to See a Subset of the Data

The Search Wizard allows you to filter the data you want to work with by specifying a query. You can access the Search Wizard in both the Data Manager and Merge Manager tools. The instructions in this section apply to both tools.

To use the Search Wizard to see a subset of the data:

In the

Query

list (of either the Data Manager or Merge Manager tool), choose

Use Search Wizard

After you have filled in the form, do one of the following:

In the Data Manager, click

Begin Administration

In the Merge Manager, click

Begin Merge

If the Welcome screen is displayed, click Next
.

The Informatica MDM Hub Search Wizard is displayed.

If you want to retrieve all rows, click

Finish

without specifying any parameters.

Click

Add Parameters

to add a new parameter.

For each query parameter, specify the following settings.

Parameter	Description
Logical Conjunction	Used when multiple query parameters are defined. One of the following values: AND —Logical AND. Indicates that, for a given row, this query parameter must be True in order for the row to be included in the search results. OR —Logical OR. Indicates that, for a given row, this query parameter (or another query parameter) must be True in order for the row to be included in the search results. For queries involving multiple query parameters, the conjunctions must be either all AND or all OR, but never a mixture of both. Mixing both will yield unpredictable results.
Column Name	Name of a column in the selected table.
Search Operator	Expression used to determine whether a row is included in the search results. One of the following values: is exactly —value in this column must be identical to the search value. begins with —value in this column must begin with the search value. ends with —value in this column must end with the search value. contains —value in this column must contain the search value. does not contain —value in this column must not contain the search value. is like —value in this column must be like the search value (includes column values that match the search value). For example, if the search value is %JO% for the last_name column, then the parameter will match column values like “Johnson”, “Vallejo”, “Major”, and so on. is not like —value in this column must not be like the search value (excludes column values that match the search value). For example, if the search value is %JO% for the last_name column, then the parameter will omit column values like “Johnson”, “Vallejo”, “Major”, and so on. is greater than —value in this column must be greater than the search value. is less than —value in this column must be less than the search value. is in between —value in this column is in between two values. is empty —this column must be empty (it cannot contain any value). is not empty —this column cannot be empty (a value is required).
Search Value	Value used in conjunction with the column name and search operator to determine whether a given row is included in the search results. You can use the % wildcard, just as you would in SQL statements. To treat the % character as a literal character instead of a wildcard, precede it with the escape character (\), as in the following example: 50\% Sale.
Ignore case	If checked (selected), then the Search Wizard treats uppercase and lowercase letters as equivalent (for example, “CA = Ca”). If unchecked (cleared), then the Search Wizard treats uppercase and lowercase letters differently (for example, “CA does not equal Ca”).

For example, you can set up the query parameter to find all records where the State column contains the string ‘NY’.