Defining Load Settings - trillium_discovery - trillium_quality - Latest

Trillium Administration Center
Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Discovery
Title
Trillium Administration Center
Copyright
2024
First publish date
2018
Last updated
2024-10-18
Published on
2024-10-18T14:53:23.000039
Change type Description
Introduced in version 17.3 Capability to define load settings

The following settings in the Administration Center can have an impact on data import performance:

  • Dependency Analysis

  • Key Analysis

  • Statistics Analysis

  • Duplicate Key Discovery

Note: They apply to all loader connections in the repository server.

To define or modify run at load settings

  1. Log in to the Administration Center.

  2. On the top Menu bar, click the Settings icon .
  3. In the Settings window, select Run at Load Time.

  4. Click the checkboxes, and modify as necessary using the instructions in the table given below.

    Table 1. Run at Load Time Setting Descriptions

    Setting

    Description

    Run statistics

    By default, Trillium automatically performs statistical analysis of numeric attributes during data import to calculate the standard deviation value.

    Disabling statistical analysis improves load performance. To disable this option, clear the Run statistics selection.

    Note: If you choose to not run the statistical analysis during data import, remember to manually run the analysis at a later time from the Discovery Center.

    To find other attribute statistics like percentile value, run percentile analysis of the attribute with numeric data in the Discovery Center.

    Discover keys

    By default, Trillium automatically performs key analysis on a sample of your data (10,000 rows) during data import to find potential keys.

    Disabling the key analysis improves the load performance. To disable this option, clear the Discover keys selection.

    Note: If you choose to not run the key analysis during data import, remember to manually run the analysis at a later time from the Discovery Center.

    Discover dependencies

    By default, Trillium automatically performs dependency analysis on a sample of your data (10,000 rows) during data import to find possible dependencies.

    Disabling the dependency analysis improves the load performance. To disable this option, clear the Discover dependencies selection.

    Note: If you choose to not run the dependency analysis during data import, remember to manually run the analysis at a later time from the Discovery Center.

    Discover Duplicate rows

    By default, Trillium identifies duplicate rows discovered during the data import process.

    To improve system performance, you can disable this feature or you can limit the number of duplicates you want found.

    To disable this option, clear the Discover Duplicate rows selection.

    To set a processing limit, enter a number in the Potential duplicates threshold field. The default value is 10,000.
  5. Click Save to save your changes. (Click Cancel to return to the previous view without saving changes.)
  6. Click Close to close the window.