Data Profiling for Assets > Data profiling operations > Creating a profile
  

Creating a profile

Create a profile and associate data elements with data quality assets as rules. When you create a profile, you choose a sampling type and apply filters to the profile.
    1Open the data set for which you want to create a profile.
    2On the Data Profiling tab, perform one of the following actions:
    The New Data Profile page appears.
    3In the General Information area, enter a name and an optional description for the profile.
    4In the Profile Settings area, enter the following properties for the data profile:
    Property
    Description
    Sampling Type
    Defines the set of rows on which data profiling will run.
    Choose one of the following options:
    • - All Rows. Runs data profiling on all rows.
    • - Limit N Rows. Runs data profiling on a limited number of rows.
    • - Custom Query. Uses an SQL clause to select the rows on which data profiling will run.
    No of Rows to Limit
    Required if you select Limit N Rows as the sampling type. Specifies the number of rows on which data profiling will run.
    Sampling Query
    Required if you select Custom Query as the sampling type. Enter a custom SQL query to define the set of rows on which data profiling will run.
    For example: WHERE LAST_NAME LIKE 'P%'
    5Optionally, in the Filters area, select Yes to define one or more filters that the profile can apply to the data.
    You can define filter conditions as follows:
    1. aChoose a data element and an operator, and then enter one or more filter values. Multiple values within the filter have an OR relationship.
    2. bClick Add to define an additional filter. The filters you define have an AND relationship.
      3. The following image shows three filters:
    6In the Data Elements area, click Add to choose the data elements that you want to include in the profile.
    7Click Next.
    8Add one or more rules to the profile.
    9Click Save to save the profile, or click Save and Run to save the configuration and run the profiling job.

Adding rules to a profile

Associate data quality assets as rules to data elements.
    1After you configure the properties on the Overview tab, click Next to go to the Rules tab.
    2On the Rules tab, click Add Rule.
    The Add Rule page appears.
    3Choose the data quality asset that you want to run as a rule within the profile, and click Next.
    You can choose a rule specification, cleanse, parse, or verifier asset.
    4Select the data elements to which you want to apply the rule.
    If the data quality asset has a single input field, choose one or more columns for the rule field.
    If the asset has multiple input fields, choose a single column for each rule field.
    Note: To automatically associate rule fields with columns based on matches between the rule field and the column names, click Auto-assign.
    5Optionally, add additional rules.
    6Click Finish.