Column Patterns

The column patterns include the patterns for the column values and the frequency in which the patterns appear. The column patterns also include a pie chart that represents the patterns and frequencies.

The profiling warehouse stores 16,000 unique highest frequency values including NULL values for profile results by default. If there is at least one NULL value in the profile results, the Analyst tool can display NULL values as patterns.

Note: The Analyst tool cannot derive the pattern for a numeric column that has a precision greater than 38. The Analyst tool cannot derive the pattern for a string column that has a precision greater than 255.

Property	Description
Pattern	Pattern for the column in the profile.
Frequency	Number of times a pattern appears for a column, expressed as a number.
Percent	Percentage that a pattern appears for a column.
Chart	Chart for the percentage.
Drill down	Drills down to specific source rows based on a column pattern.

Character	Description
9	Represents any numeric character. Informatica Analyst displays up to three characters separately in the "9" format. The tool displays more than three characters as a value within parentheses. For example, the format "9(8)" represents a numeric value with eight digits.
X	Represents any alphabetic character. Informatica Analyst displays up to three characters separately in the "X" format. The tool displays more than three characters as a value within parentheses. For example, the format "X(6)" might represent the value "Boston." Note: The pattern character X is not case sensitive and might represent uppercase characters or lowercase characters from the source data.
p	Represents "(", the opening parenthesis.
q	Represents ")", the closing parenthesis.
b	Represents a blank space.