You can profile wide tables and flat files that have a maximum of 1000 columns. When you create or run a profile, you can choose to select all the columns or select each column for a profile. You can select all columns to drill down and view value frequencies for these columns. You cannot select a column to run a profile in the delimited file if the column name exceeds 245 characters.

You cannot run a profile on the semi-structured data sources on the Spark engine.

You can create column profiles with the following methods in Informatica Analyst:

Right-click the data object in the
Library
workspace to create a profile.
Use default options to create a default column profile.
Customize the settings for the profile to create a custom profile.