Table of Contents

Search

  1. Preface
  2. Introduction
  3. Getting Started with the MDM Hub Console
  4. Consolidating Data
  5. Managing Data
  6. Using the Hierarchy Manager
  7. Glossary

Using the Search Wizard to See a Subset of the Data

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:
  1. In the
    Query
    list (of either the Data Manager or Merge Manager tool), choose
    Use Search Wizard
    .
  2. 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
      .
  3. 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.
  4. Click
    Add Parameters
    to add a new parameter.
  5. 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’.
  6. Click
    Finish
    .

0 COMMENTS

We’d like to hear from you!