Adding a Load Process - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

A Load process is added as a branch off a workflow to create a fully loaded and analyzed entity. From its output entity you drill down to view entity and attribute metadata. This is useful if you want to load data into and analyze a dynamic input entity, as well as run analysis on the output data from a Quality process.

Note: The Load process can only be used on a dynamic input entity or on the output from a Quality process; it cannot be used on an entity that is already fully loaded. For example, if the input entity is real, add a Transformer process first, then add the Load process.

To add and run a Load process and view results

  1. From the Navigation or Project View, right-click the entity from which to add a branch and select Add process branch. The Create Process window opens.
  2. In Process selection, select Load.
  3. Click OK. The Load process branch is added to the project. A dotted line connects the input entity to the process. The output of the process is added to the Entities tab if the data input to the process is dynamic.
  4. To run the process, right-click the process and select Run. If the process is added to the output of a Quality process, ensure that process has already run. The Execute Process window opens.
  5. (Optional) Select Include dependent processes to run all processes that are branched off the current process. Select Use pipes. For details about using pipes, see the guidelines in Profiling Processes.
  6. Click Run.
  7. To view entity analysis results: 
    1. Right-click the output entity and select Tools > Drill down to metadata. The Entity List View opens, showing the metadata results.
    2. Double-click a row to view the analysis results for the metadata you are interested in. For example, to see all keys discovered when the Load process was run, double-click the Discovered Keys row.
  8. To view attribute analysis results:
    1. Right-click the output entity and select Tools > Drill down to attributes. The Entity Member Attributes List View opens, showing a selection of the discovered metadata for the attributes in the entity.
    2. To view all available attribute metadata, right-click any column label and select Choose Columns. Move the hidden fields to the displayed fields list and click OK.
  9. Other tasks available from the output entity include:
    • Creating keys and dependencies
    • Creating and viewing business rules
    • Adding other profiling processes as process branches