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
-
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.
-
In Process selection, select Load.
-
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.
-
See example:
-
-
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.
-
(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.
-
Click Run.
-
To view entity analysis results:
-
Right-click the output entity and select Tools > Drill down to metadata. The Entity List View opens, showing the metadata results.
-
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.
-
To view attribute analysis results:
-
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.
-
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.
-
Other tasks available from the output entity include:
- Creating keys and dependencies
- Creating and viewing business rules
- Adding other profiling processes as process branches