Part III: Data Discovery with Informatica Developer > Column Profile Results in Informatica Developer > Column Pattern Properties
  

Column Pattern Properties

Column pattern properties show the patterns of data in the profiled columns and the frequency with which the patterns appear in each column. The patterns are shown as a number, a percentage, and a bar chart.
To view pattern information, select Patterns from the Show list. Double-click a pattern to drill-down to the rows that contain the pattern.
The following table describes the properties for column value patterns:
Property
Description
Patterns
Pattern for the selected column.
Frequency
Number of times a pattern appears in a column.
Percent
Number of times a pattern appears in a column, expressed as a percentage of all values in the column.
Chart
Bar chart for the percentage.