You can create and run a profiling task to view and analyze the content and structure of a source object.
1In Data Profiling, click New.
2In the New dialog box, click Data Profiling Task.
The Profile page contains a Definition tab and a Schedule tab.
3On the Definition tab, enter the asset, source, and profile details. Select the data set that in which you expect to find exception records. You can also choose columns and add a filter for the profiling task. Select the columns that may contain the exception data.
Based on the source object and the attributes that you choose, Data Profiling adds a Rules tab to the profiling task.
4On the Rules tab, add one or more Data Quality assets as rules to the profiling task.
- You can add a cleanse, labeler, parse, or rule specification asset to view the impact of the corresponding data quality operations on the source data.
- Select a rule specification that can add exception indicators to the source data.
Note: The properties on one or more of the inputs that you defined in the rule specification must match the columns that the profiling task will examine for exception data.
5On the Schedule tab, optionally choose a runtime environment and schedule. You can also change the default email notification options and advanced options for the profile run as necessary.
6 Choose one of the following options to save and run the profiling task:
- Click Save to save the profiling task.
- Click Run to save and run the task. You run the task to generate a profile of the source data.
- Save the profiling task and choose a schedule on the Schedules tab to run the profiling task.