Data Profiling a Synonym or Segment

Data Profiling provides information on all the columns in a synonym or segment. You can also drill down to the Values or Patterns reports for an individual column from a synonym or segment Data Profiling report.


Top of page

x
Procedure: How to View Data Profiling for a Synonym or Segment

To view the Data Profiling information for a synonym or segment:

  1. Select a synonym or segment name. Next, click Data Profiling from the Report group and click Statistics or right-click the synonym or segment name, select Data Profiling, and then Statistics.

    The Data Profiling information displays in the workspace. The last four columns are shown below the rest of the information for illustrative purposes only. The actual report runs across the workspace.

    You may use the Data Profiling Results toolbar to view server messages, print the report, copy data as text, and export the report.

  2. Optionally, you can click a column name or patterns count (for alphanumeric columns) to drill down to the Values or Patterns reports, respectively.

    This is a partial Values report produced by clicking a column name.

    For pattern analysis, a 9 represents a digit, an A represents any uppercase letter, and an a represents any lowercase letter. All printable special characters are represented by themselves and unprintable characters are represented by an X.