SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

Column Null Ratio Profile Request Options (Data Profiling Task)

SQL Server 2012

Use the Request Properties pane of the Profile Requests page to set the options for the Column Null Ratio Request selected in the requests pane. A Column Null Ratio profile reports the percentage of null values in the selected column. This profile can help you identify problems in your data such as an unexpectedly high ratio of null values in a column. For example, a Column Null Ratio profile can profile a ZIP Code/Postal Code column and discover an unacceptably high percentage of missing postal codes.

Note Note

The options described in this topic appear on the Profile Requests page of the Data Profiling Task Editor. For more information about this page of the editor, see Data Profiling Task Editor (Profile Requests Page).

For more information about how to use the Data Profiling Task, see Setup of the Data Profiling Task. For more information about how to use the Data Profile Viewer to analyze the output of the Data Profiling Task, see Data Profile Viewer.

For a Column Null Ratio Request, the Request Properties pane displays the following groups of options:

  • Data, which includes the TableOrView and Column options

  • General

Data Options

ConnectionManager

Select the existing ADO.NET connection manager that uses the.NET Data Provider for SQL Server (SqlClient) to connect to the SQL Server database that contains the table or view to be profiled.

TableOrView

Select the existing table or view that contains the column to be profiled.

For more information, see the section, "TableorView Options," in this topic.

Column

Select the existing column to be profiled. Select (*) to profile all columns.

For more information, see the section, "Column Options," in this topic.

TableOrView Options

Schema

Specifies the schema to which the selected table belongs. This option is read-only.

Table

Displays the name of the selected table. This option is read-only.

Column Options

IsWildCard

Specifies whether the (*) wildcard has been selected. This option is set to True if you have selected (*) to profile all columns. It is False if you have selected an individual column to be profiled. This option is read-only.

ColumnName

Displays the name of the selected column. This option is blank if you have selected (*) to profile all columns. This option is read-only.

StringCompareOptions

This option does not apply to the Column Null Ratio Profile.

General Options

RequestID

Type a descriptive name to identify this profile request. Typically, you do not have to change the autogenerated value.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.