OWB 11gR2 – Mapping productively

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).
    • image
  • Drag from an output (or input/output) attribute group to an input (or input/output) attribute group that contains more than one displayable attributes.
    • image
  • 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.
    • image
  • Right click on one of the mapping objects (operator, attribute group or attribute) and click the new popup menu item "Connect To".
    • image
  • Double click on an existing mapping line.
    • image 

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.

image

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';

image

The dialog has flexible auto-mapping capabilities also, so can type in a prefix to ignore such as 'M_' and name matching will occur;

image

You can then preview the changes that were mapped;

image 

So iconic level mapping can be used;

image

with the drill into detail by double clicking on the mapping line;

image

Plus the traditional graphical view is still available;

image

There is an 11gR2 OBE which covers the new 'AutoMapper' here, hopefully this will help you with some additional ideas for managing your designs.

Comments:

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