Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Find in Workspace

Find in Workspace

You can search for a string in the Save, Generate, or Validate tabs in the Output window. The Find in Workspace tool searches for a field name or transformation name in all transformations in the workspace.
The Find in Workspace tool lets you to search all of the transformations in the workspace for port or transformation names. You can search for column or port names or table names matching the search string. You can specify whether to search across all names in the workspace, or across the business name of a table, column, or port. You can also choose to search for whole word matches for the search string or matches which match the case of the search string.
To find a column, port, or transformation name in the workspace:
  1. In a Designer tool, click the Find in Workspace button, or click Edit > Find in Workspace.
    The Find in Workspace dialog box opens.
  2. Choose to search for field names or table names matching the search text.
    Look for Option
    Description
    Fields
    Designer searches for column or port names matching the search text.
    Tables
    Designer searches for table names matching the search text.
  3. Specify the search string in the Find What entry field, or select a search string from the list.
    The Designer saves the last 10 search strings in the list.
  4. Specify whether you want to look for matches to the search text among all names or business names.
    Find In Option
    Description
    Names
    Designer searches across all names of tables, columns, or ports in the workspace.
    Business Names
    Designer searches across the business names of tables, columns, or ports in the workspace.
  5. Specify search criteria.
    Search Option
    Description
    Look in all Tables
    Select this option to search across all tables in the workspace. If you do not select this option, the Designer searches across all currently selected tables in the workspace. This option is selected when you search for table names matching the search string.
    Match Whole Word Only
    Select this option to find names or business names that match the specified string.
    Match Case
    Select this option if you want to search for strings that match the case of the specified search string.
  6. Click Find Now.
    All matches appear in the table at the bottom of the Find in Workspace dialog box.
  7. Click Close.


Updated June 25, 2018