Connection name to the profiling warehouse database. In addition to the profile results, the profiling warehouse holds the persisted profile job queue. Verify that no profile job runs when you change the connection name. Otherwise, the profile jobs might stop running because the profile jobs run on the Data Integration Service where the Profiling Service Module submitted the profile jobs.

The number of minimum values and maximum values to display for a profile based on the datatype of the column. Ranks are useful to understand the range that the values of a column might take and whether the column has pseudonull values. You can retain the default value.

The maximum number of patterns that each column stores. Sometimes, it is important to store as many patterns as possible. You can set the

Maximum Patterns

parameter to a large number, such as 10,000, and adjust the

Pattern Threshold Percentage

parameter to

.01

. Setting a high value for this parameter has negligible impact on performance.

The number of profile mappings that the Profiling Service Module can run concurrently when the Data Integration Service runs on a single node or on a grid. The pool size is dependent on the aggregate processing capacity of the Data Integration Service, which you specify for each node on the

Processes

tab of the Administrator tool. The pool size cannot be greater than the sum of the processing capacity of all nodes.

The number of parallel queries across all the profiling jobs for a relational source. If two profile jobs run on the same database, each profile job gets half the number of connections. If two profile jobs run on different databases, each profile job gets the maximum number of connections.

The default path where the Profiling Service Module stores the exported objects, such as Microsoft Excel spreadsheets and DDL files.