Table of Contents

Search

  1. Preface
  2. Introduction to Informatica MDM - Customer 360
  3. Getting Started
  4. Adding Records
  5. Finding Records
  6. Editing Records
  7. Working with Drafts
  8. Participating in Review Processes
  9. Importing Data
  10. Resolving Duplicates
  11. Investigating Data Changes
  12. Investigating Hierarchies and Relationships
  13. Viewing the Relationship Graph

Basic Queries

Basic queries use simple text comparisons to find records that contain the query values. You can use text and the wildcard character (*) to query values.
The wildcard characters are special search symbols that you can use in basic queries to specify a text pattern instead of specific characters. You can use the asterisk (*) wildcard character to increase your chances of finding the records that you want. The wildcard characters are useful when you do not know the exact text or want to search for similar text.
The following table lists example search strings and explains how they function:
Example Query String
Query Behavior
John Smith
Queries for records that contain
John
,
Smith
, or any variations of
John
or
Smith
as a field value.
"John Smith"
Queries for records that contain
John Smith
or any variations of
John Smith
as a field value.
John*
Queries for records that contain a value that starts with
John
. For example,
Johnson
or
Johnny
.
Jo*n
Queries for records that start with
Jo
and end with
n
. For example,
Johansson
or
Jordan
.
*
Returns all the records.
Basic query is not case sensitive in Microsoft SQL Server environments.

0 COMMENTS

We’d like to hear from you!