Tek tablo hızlı profil formuna (görev profil oluşturma veri)
Use the Single Table Quick Profile Form to configure the Data Profiling task quickly to profile a single table or view by using default settings.
Profil oluşturma veri görevi'ni kullanma hakkında daha fazla bilgi için bkz: Görev için profil oluşturma verileri ayarlama. For more information about how to use the Data Profile Viewer To analyze the output of the Data Profiling Task, see Profil çıkış veri profil Görüntüleyicisi'nde görüntüleme.
Seçenekler
Bağlantı
Select an 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.Tablo veya Görünüm
Select an existing table or view in the database to which the selected connection manager connects.Compute
Select which profiles to compute.Değer
Açıklama
Column Null Ratio Profile
Compute a Column Null Ratio profile by using the default settings for all applicable columns in the selected table or view.
This profile reports the percentage of null values in the selected column.Bu profil verilerinizi beklenmedik biçimde yüksek bir null değerleri oranı gibi sorunları tanımlamanıza yardımcı olabilecek bir sütun.For more information about the settings for this profile, see Sütun null oranı profil isteği Seçenekler'i (veri görev profil oluşturma).
Column Statistics Profile
Compute a Column Statistics profile by using the default settings for all applicable columns in the selected table or view.
This profile reports statistics such as minimum, maximum, average, and standard deviation for numeric columns, and minimum and maximum for datetime columns.Bu profil verilerinizi geçersiz tarih gibi sorunları tanımlamanıza yardımcı olabilir.For more information about the settings for this profile, see Sütun istatistikleri profil isteği (veri görev profil oluşturma) seçenekleri.
Column Value Distribution Profile
Compute a Column Value Distribution profile by using the default settings for all applicable columns in the selected table or view.
This profile reports all the distinct values in the selected column and the percentage of rows in the table that each value represents.This profile can also report values that represent more than a specified percentage of rows in the table.This profile can help you identify problems in your data such as an incorrect number of distinct values in a column.For more information about this profile, see Sütun değeri dağıtım profili isteği Seçenekler'i (veri görev profil oluşturma).
Column Length Distribution Profile
Compute a Column Length Distribution profile by using the default settings for all applicable columns in the selected table or view.
This profile reports all the distinct lengths of string values in the selected column and the percentage of rows in the table that each length represents.This profile can help you identify problems in your data, such as values that are not valid.For more information about the settings for this profile, see Sütun uzunluğu dağıtım profili isteği Seçenekler'i (veri görev profil oluşturma).
Column Pattern Profile
Compute a Column Pattern profile by using the default settings for all applicable columns in the selected table or view.
This profile reports a set of regular expressions that cover the values in a string column.This profile can help you identify problems in your data, such as strings that are not valid.This profile can also suggest regular expressions that can be used in the future to validate new values.For more information about the settings for this profile, see Sütun deseni profil isteği seçenekleri (veri görev profil oluşturma).
Candidate Key Profile
Compute a Candidate Key profile for column combinations that include up to the number of columns that is specified in for up to N Column keys.
This profile reports whether a column or set of columns is appropriate to serve as a key for the selected table.This profile can also help you identify problems in your data, such as duplicate values in a potential key column.For more information about the settings for this profile, see Aday anahtar profil isteği (veri görev profil oluşturma) seçenekleri.
for up to N Column keys
Select the maximum number of columns to test in possible combinations as a key for the table or view.Varsayılan değer 1’dır.En büyük değer 1000'dür.For example, selecting 3 tests one-column, two-column, and three-column key combinations.
Functional Dependency Profile
Compute a Functional Dependency profile for determinant column combinations that include up to the number of columns that is specified in for up to N Columns as the determiner.
This profile reports the extent to which the values in one column (the dependent column) depend on the values in another column or set of columns (the determinant column).This profile can also help you identify problems in your data, such as values that are not valid.For more information about the settings for this profile, see Işlev bağımlılık profil isteği seçenekleri (veri görev profil oluşturma).
for up to N Columns as the determiner
Select the maximum number of columns to test in possible combinations as the determinant columns.Varsayılan değer 1’dır.En büyük değer 1000'dür.For example, selecting 2 tests combinations in which either single columns or two-column combinations are the determinant columns for another (dependent) column.
Not
The Value Inclusion Profile type is not available from the Single Table Quick Profile Form.