Use the Impact view to see resource links
The Impact view shows how Designer objects such as metadata, processes, or mappings are used. In the default view, it is found in the Impact tab, next to the Runtime tab under the project list.
This article uses examples to show you different ways of using the Impact view to see and trace object dependencies.
Find the parent metadata of a sub-metadata object
The examples in this section show two Oracle databases that each have a schema named ORDER_SCHEMA. The metadata contains ORDER_SCHEMA sub-metadata objects in a project named 20.
Shipping reports.
In the Project Explorer, select the object you want to analyze, and open the Impact view.
Click on the Show Impact button with a yellow double arrow.
Clicking the button displays your object in the Impact view, along with Uses and Children nodes. Double-click on the schema under the Uses node. It opens the metadata that was used to create the sub-metadata file.
Finding mappings or processes that use a table
You can use the Impact view to find which mappings or processes are using a table.
In the Project Explorer, select the table you want to analyze, and open the Impact view. Click on the Show Impact button with a yellow double arrow.
The Impact view displays the table object along with various other nodes. The Used By node shows which other resources use the table.
Double-click on these resources to open them directly in Designer
| Instead of selecting a table from the Project Explorer, you can also select a metadata object from the mapping editor, then continue in the Impact view. |
Find processes that use a mapping or process
You can also use the Impact view to find which processes use a mapping or another process.
Open the mapping or process for which you want to find the containing process, and open the Impact view. Click on the Show Impact button with a yellow double arrow.
You can find the resources in the Impact view nodes, as in the previous sections. Double-click on the process under the Used By node to open the containing process.