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 sampling options, drill-down options, and run-time environment.
The following steps describe the column profiling process:
- 1. Choose a name, description, and location for the column profile.
- 2. Select an imported data object or an external source that you want to run the profile on.
- 3. Optionally, preview the source data.
- 4. Select the columns you want to run the profile on.
- 5. Determine whether you want to create the profile with the default options or change the default options. The options that you can configure include sampling options, drill-down options, and run-time environment.
- 6. Optionally, add rules and filters when you create the profile.
- 7. Run the profile.
Note: Consider the following rules and guidelines for column names and profiling multilingual and Unicode data:
- •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 data types 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.