Table of Contents

Search

  1. Introduction to Data Discovery
  2. Data Discovery with Informatica Analyst
  3. Data Discovery with Informatica Developer
  4. Function Support Based on Profiling Warehouse Connection

Data Discovery Guide

Data Discovery Guide

Discovery Search Options

Discovery Search Options

You can perform a global search or discovery search to find assets and identify relationships to other assets. Global search retrieves results from the Model repository and optionally, Business Glossary. Discovery search retrieves results from the Model repository and Business Glossary, in addition to profiles based on profile results in the profiling warehouse.
You can search for assets, such as data objects, profiles, and mapping specifications. Enter a search string to search for assets that match the search string and have an association with the search string. You can use wildcard characters when you search for assets.
You can use the following wildcard characters when you search for assets:
* (Asterisk)
Add to the end of the search string to find all asset names that start with the search string. For example, to search for all asset names starting with the "emp" string, you can type in "emp*" in the search field.
? (Question mark)
Include in the search string to represent an alphanumeric character.
You cannot start a search string with a wildcard character when you search for assets. The search is not case sensitive.
To search for two or more words together as a phrase, include the words in double quotation marks. Use the character
+
to represent the AND operator and search for a term that must appear in the search results. For example, if the search string is
+sensitive +data
, Search Service finds metadata that includes both the terms. Use a blank space to represent the OR operator. For example, if the search string is
sensitive data
, the Search Service finds metadata that contains either one of the terms.
If the search string contains a hyphen (-), underscore (_), or camel case, the Search Service finds the whole word and part words separated by the delimiter. For example, if you search for
Profile_Customer
, the search engine finds
Profile
,
Customer
, and
Profile_Customer
in the repositories. To include special characters, such as
*
and
?
, in your search string, include the search string that contains special characters in double quotes.
You can perform a discovery search that includes a keyword search and discovery filter. For example, you might want to find employee ID columns that use the format
<FirstNameInitial><LastnameInitial>-<SSN>
so that you can identify data security risks. To search for the employee ID columns, enter
Employee ID
in the
Search
panel of the Library workspace and set the pattern filter to
XX-999999999 <= 100%
.

0 COMMENTS

We’d like to hear from you!