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. You can choose a run-time environment. 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 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.
Note: You can view and run the profile on Avro, JSON, Parquet, and XML data sources. You can create and edit a column profile on Avro, JSON, Parquet, and XML data sources in the Informatica Developer.