You can open the editor of any system or user-defined indicator to check its settings and/or edit its definition and metadata in order to adapt it to a specific database type or need, if required.
Before you begin
At least one user-defined indicator is created in the Profiling perspective of Talend Studio.
- In the DQ Repository tree view, expand , and then browse through the indicator lists to reach the indicator you want to modify the definition of.
Right-click the indicator name and select Open from the contextual menu.
The indicator editor opens displaying the selected indicator settings.
- Modify the indicator metadata, if required.
Click Indicator Category to open the view and select an
indicator category from the list:
Indicator category Description User Defined Match (by-default category) Uses user-defined indicators to evaluate the number of the data records that match a regular expression or an SQL pattern. The analysis results show the record matching count and the record total count. User Defined Frequency Uses user-defined indicators for each distinct data record to evaluate the record frequency that match a regular expression or an SQL pattern. The analysis results show the distinct count giving a label and a label-related count. User Defined Real Value Uses user-defined indicators which return real value to evaluate any real function of the data. User Defined Count Uses user-defined indicators that return a row count.If you change the indicator category, you can keep the existing indicator definition or remove the indicator definitions for all databases but the one for Java.
Click Indicator Definition to open the
view. Set the indicator definition for one or more databases using the
If the indicator is simple enough to be used in all databases, select
Defaultin the list.
Click Indicator Parameter and modify the
indicator parameters as needed.
- To add new default parameters, click the [+] button at the bottom of the table, click in the lines and define the parameter keys and values.
- Click the save icon on top of the editor to save your changes.