OWB 11gR2 – Mapping productively
By David Allan-Oracle on Aug 18, 2010
A productivity feature that was added into OWB 11gR2 was the quick mapper, it replaced the existing auto-mapper and provides an accelerated way of mapping in a spreadsheet manner. As well as auto-mapping capabilities the dialog provides search, sort and auto-completion functionality on the attribute level to reduce the amount of time necessary to perform such mapping graphically (which is still possible). This is very useful when you have large tables or operators that are being mapped, managing them in a spraedsheet is simpler rather than graphically which can be challenging at times with layouts and so on.
The mapping connection dialog can be launched in one of the following ways:
- Drag from an iconized operator to another iconized operator (and operators are not yet connected to each other).
- Drag from an output (or input/output) attribute group to an input (or input/output) attribute group that contains more than one displayable attributes.
- Drag from more than one selected output (or input/output) attribute to an input (or input/output) attribute group that contains more than one displayable attribute.
- Right click on one of the mapping objects (operator, attribute group or attribute) and click the new popup menu item "Connect To".
- Double click on an existing mapping line.
The spreadsheet mapping dialog lets you map from source to target or target to source. There is search and filtering in the spreadsheet so you can type an initial letter such as 'M' and restrict the columns and continuing typing will further restrict. Typing an '*' will let you see all columns. Below you can see the 3 attributes that start with 'M' from the source operator.
If we concentrate on mapping from the source for example if we type the target column name, and enter 'C' we can see the target columns that start with 'C';
The dialog has flexible auto-mapping capabilities also, so can type in a prefix to ignore such as 'M_' and name matching will occur;
You can then preview the changes that were mapped;
So iconic level mapping can be used;
with the drill into detail by double clicking on the mapping line;
Plus the traditional graphical view is still available;
There is an 11gR2 OBE which covers the new 'AutoMapper' here, hopefully this will help you with some additional ideas for managing your designs.