A Keys process is added to a workflow to create permanent keys on the attributes you select. After you run the process, you can view the created keys and research duplicate keys. You can also add an Analysis or Load process branch off the output entity.
Note: Keys do not support dynamic entities. Use only real entities to create keys.
To add and run a Keys process and view results
-
From the Navigation or Project View, right-click the input entity or the output from a Load process and select Add process branch. The Create Process window opens.
Note: If you plan to copy the Keys process to the Library, you must add it to a Load process. The Load process must then be copied to the Library along with the Keys process.
- In Process selection, select Keys.
-
Click OK. The Keys process branch is added to the flow. A dotted line connects the input entity to the process. In the Navigation View, the new process displays at the end of the list of processes.
- See example:
-
- Right-click the Keys process and select Edit process. The Select attributes window opens, showing all attributes in the entity.
- Check the attributes you want to comprise the key.
- Click OK.
- Right-click the process and select Run. The Execute Process window opens.
- (Optional) Select Include dependent processes to execute 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.
- After the process runs, double-click the output entity to see any duplicate keys found. The Duplicate Keys List View opens. Duplicate keys indicate key values that are non-unique and so are not good candidates for permanent keys.
-
Drill down to see other metadata results:
- Right-click the input entity.
- Select Tools > Drill down to metadata. The Entity List View opens. The Permanent Keys row shows how many permanent keys were created.
- Double-click Permanent Keys. The Keys List View opens showing the analysis metadata. The number of rows displayed depends on how many keys were created. The LH Attrs column shows the attributes that make up each key. To increase the number of keys found, increase the number of attributes analyzed and run the process again.
-
To work with key results, including working with duplicate keys, click the following links:
Related concepts