Column Profiling Process
As part of the column profiling process, you can choose to either include all the source columns for profiling or select specific columns. You can also accept the default profile options or configure the profile results, sampling, and drill-down options.
The following steps describe the column profiling process:
- 1. Select the data object you want to profile.
- 2. Determine whether you want to create a profile with default options or change the default profile options.
- 3. Choose where you want to save the profile.
- 4. Select the columns you want to profile.
- 5. Select the profile results option.
- 6. Choose the sampling options.
- 7. Choose the drill-down options.
- 8. Define a filter to determine the rows that the profile reads at run time.
- 9. Run the profile.
Note: Consider the following rules and guidelines for column names and profiling multilingual and Unicode data:
- •You cannot add a column to a profile if both the column name and profile name match. You cannot add the same column twice to a profile even if you change the column name.
- •You can profile multilingual data from different sources and view profile results based on the locale settings in the browser. The Analyst tool changes the Datetime, Numeric, and Decimal datatypes based on the browser locale.
- •Sorting on multilingual data. You can sort on multilingual data. The Analyst tool displays the sort order based on the browser locale.
- •To profile Unicode data in a DB2 database, set the DB2CODEPAGE database environment variable in the database and restart the Data Integration Service.