Part II: Data Discovery with Informatica Analyst > Column Profiles in Informatica Analyst > Profile Options
  

Profile Options

Profile options include profile results option, data sampling options, and data drilldown options. You can configure these options when you create a column profile for a data object.
You use the New Profile wizard to configure the profile options. You can choose to create a profile with the default options for columns, sampling, and drilldown options. When you create a profile for multiple data sources, the Analyst tool uses default column profiling options.

Profile Results Option

You can choose to discard previous profile results or to display results for previous profile runs.
The following table describes the profile results option for a profile:
Option
Description
Show results for columns and rules you selected in the current profile run
Discards the profile results for columns that you previously ran a profile on and displays results for the columns and rules selected for the latest profile run. Do not select this option if you want the Analyst tool to display profile results from columns that you previously ran a profile on.

Sampling Options

Sampling options determine the number of rows that the Analyst tool chooses to run a profile on. You can configure sampling options when you define a profile or when you run a profile.
The following table describes the sampling options for a profile:
Option
Description
All Rows
Chooses all rows in the data object.
First <number> Rows
The number of rows that you want to run the profile against. The Analyst tool chooses the rows from the first rows in the source.
Random Sample <number> Rows
The number of rows for a random sample to run the profile against. Random sampling forces the Analyst tool to perform drilldown on staged data. Note that this can impact drilldown performance.
Random sample
Random sample size based on the number of rows in the data object. Random sampling forces the Analyst tool to perform drilldown on staged data. Note that this can impact drilldown performance.
Exclude datatype inference for columns with an approved datatype
Excludes columns with an approved datatype from the datatype inference of the profile run.

Drilldown Options

You can configure drilldown options when you define a profile or when you run a profile.
The following table describes the drilldown options for a profile:
Options
Description
Enable Row Drilldown
Drills down to row data in the profile results. By default, this option is selected.
Select Columns
Identifies columns for drilldown that you did not select for profiling.
Drilldown on live data
Drills down on live data to read current data in the data source.
Drilldown on staged data
Drills down on staged data to read profile data that is staged in the profiling warehouse.