OWB 11gR2 – Copy Paste for productivity
By David Allan-Oracle on Aug 16, 2010
Another one of those 'wish you could' capabilities, that now you can. The copy-paste capabilities in OWB 11gR2 let you copy-paste operators, groups and attributes amongst mappings. The copy-paste of attributes and groups is especially useful for building expression operator outputs (in a 'backwards' mapping style), I'm sure you'll find many other uses. You can copy both within and across mappings as you'd expect.
So how does it work? Simple select the operator, group or selection of attributes you want to copy, right click and select copy in the pop-up menu.
You can then paste into the output group of the operator (any operator - expressions, aggregators, tables and so on). This will paste the entire attribute definition including the name, data type with characteristics (time saver) - for expressions a default expression is also added.
You can then use the operator editor which has also been enhanced to edit all expressions in a spreadsheet. By clicking on the '...' button in the table (shown below) you get the expression editor, but can also just type in the expression for faster input.
To reiterate you can copy object operator(s) or group or attributes, operators can then be pasted to a mapping canvas, groups get pasted to a selected operator, and attributes get pasted to a selected group within an operator. Copying operators is a useful way of capturing the definition for example if you wanted to build a pluggable mapping from a mapping design that was not initially constructed in such a manner without rekeying operators.