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.
To view the Data Profiling information for a synonym or segment:
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.
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.