Column Profiles in Informatica Analyst Overview
When you create a profile, you select the columns in the data object for which you want to profile data. You can set or configure sampling and drilldown options for faster profiling. After you run the profile, you can examine the profiling statistics to understand the data.
You can profile wide tables and flat files that have a large number of columns. You can profile tables with more than 30 columns and flat files with more than 100 columns. When you create or run a profile, you can choose to select all the columns or select each column you want to include for profiling. The Analyst tool displays the first 30 columns in the data preview. You can select all columns for drilldown and view value frequencies for these columns. You can use rules that have more than 50 output fields and include the rule columns for profiling when you run the profile again.