Column Profiles in Informatica Analyst Overview
When you create a profile, you select the columns in the data object on which you want to run a profile. You can configure the sampling and drill-down options for faster profiling. When you create a profile, you can add rules and filters to the profile. 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 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 for drilldown and view value frequencies for these columns.
You can create column profiles with the following methods in the Analyst tool:
- •Use default options to create a default column profile.
- •Customize the settings for the profile to create a custom profile.
- •Right-click the data object in the Library workspace to create a profile.
Note: You can view and run the profile on JSON and XML data sources. You can create a profile on JSON or XML data sources in the Developer tool.