Part II: Data Discovery with Informatica Analyst > Column Profile Results in Informatica Analyst > Column Patterns
  

Column Patterns

The column patterns include the value patterns for the columns and the frequency in which the pattern appears.
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.
The following table describes the properties for the column patterns:
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.
The following table describes the pattern characters and what they represent:
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 8 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)" may represent the value "Boston."
Note: The pattern character X is not case sensitive and may represent upper case or lower case characters from the source data.
p
Represents "(", the left parenthesis.
q
Represents ")", the right parenthesis.
b
Represents a blank space.