Configure Permanent Join Analysis - trillium_discovery - 17.1

Trillium Discovery Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
17.1
Language
English
Product name
Trillium Discovery
Title
Trillium Discovery Center
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

The final step to adding a permanent join is to name the join analysis job and, optionally, create a join index. When a join index is created, drill-down performance to join metadata is enhanced, although the time needed to run the join analysis may increase.

To configure and finish permanent join analysis

  1. In the Create or Discover Joins window, click the Join tab. (See Creating and Discovering Joins.)
  2. Keep the default Analysis Name, or enter another name. By default, the Analysis Name field is populated as follows:

    Create-Join-left-hand source name-current date (YYYYMMDD). For example, if your left-hand source is named Boston Data and the current date is January 12, 2017, then the default analysis name would be Create-Join-Boston Data-20170112.

  3. To include an index, select Create index to see data row views. If you do not want to include a join index, ensure the check box is cleared.
  4. Select Schedule job options:
    • Select Now (the default) to schedule the job to run when you click Finish.
    • Select Later to schedule the job to run at a later time. The current date and the time at the next half hour display. To change the date, click the calendar icon () and select a starting date. To change the time, click the clock icon () and select a time you want the job to run on the selected date.
  5. Click Summary to review all selections and to make edits as needed. Click Back or In Progress to return to the Join tab.
  6. Do one of the following:
    • To add the join, click Finish. A message displays confirming the join analysis has been started or scheduled.
    • To close the window without saving your work, click Cancel or the X icon.
  7. Do one of the following:
    • Click Add Another Join to continue adding joins. See Select Data Sources for Joins.
    • Click Task Manager to open the Task Manager and monitor the status of the join analysis job if run now. Scheduled tasks show a status of pending.
    • Click Done to close the window.

    To review join analysis results, see Viewing Join Metadata and Venn Diagrams.