For example, an application contains the following mapping that reads data from an Oracle table, filters the data, and writes data to a flat file:

To change the source database between mapping runs, the mapping designer creates a connection parameter for the source connection and assigns it the default value Ora_DEV. The mapping designer creates a parameter set, PRODUCTION, and sets the source connection to Ora_PROD.

In Metadata Manager, you want to view the mapping and display lineage links with the values defined in the PRODUCTION parameter set. Assign the PRODUCTION parameter set to the mapping when you create the resource.

When you load the resource, Metadata Manager extracts the mapping using the parameter values defined in the parameter set. Therefore, when you view the resource on the Load tab, the Connection Assignment tab shows the connection as Ora_PROD. If you run data lineage on the mapping and select the relational source, Metadata Manager displays the connection name as Ora_PROD. Metadata Manager creates lineage links based on the Ora_PROD connection.