OWB 11gR2 – Copy Paste for productivity

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.

image

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.

image

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.

image

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.

Comments:

There is an OBE for this below under 'Copying Attributes and Inline Editing in Expression Operator'; http://www.oracle.com/technology/obe/11gr2_db_prod/bidw/owb/eup/combined_improved_graphical_enhancing_usability.htm#t1 Also worth checking out is the new automapper, which was internally named 'quick mapper' which gives a spreadsheet style mapper. Cheers David

Posted by David on August 16, 2010 at 08:08 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today