Oracle Read - Oracle Blogs Aggregator

Here we’ll see how you can add runtime variables and reference them from code template mappings in OWB 11gR2; variables can be used in many places including expressions, filters, joiners and execution unit code template assignments. This lets you control how some aspects of the mapping will behave at execution time. Traditional database resident mappings support mapping input parameters, in 11gR2 the template mappings can be extended in many ways and this is one illustration.
This is essentially a small extension where a table holding the variable names and values is defined, a data source in the agent to identify where

…click on the title to read the full article…