OWB - Binding a Relational Table to a Dimensional Object

Card Puncher Data Processing

Choose the Select an existing option and then select the data object from the list of objects displayed in the selection tree.
  • Click OK. A node representing the object that you just added is displayed on the canvas.
To map to the implementation object columns, hold down your mouse on the dimension or cube attribute, drag, and then drop on the column that stores the attribute value and that have on its sides the three blue circle.
For Dimension
  1. For dimensions, if more than one data object is used to store the dimension data, add more object to the canvas
  2. For dimensions, map the attributes in each level of the dimension to the columns that store their data. Also map the level relationships to the database column that store their data.
Owb Dimension Manual Binding
For cubes
Map the measures and dimension references to the columns that store the cube data.
Owb Dimensional UnbindWarehouse Builder also enables you to unbind a dimensional object. Unbinding removes the connections between the dimensional object and the tables that store its data.To unbind a dimensional object from its current implementation, right-click the dimensional object on the Relational tab of the Canvas and select Unbind. Unbinding removes the bindings between the dimensional object and its implementation objects. However, it does not modify the implementation objects.
Documentation / Reference

Discover More
Dimension Details Attributes
OWB - Dimension

A dimension in OWB is a metadata construction to be able to: automatically build a table with its hierarchy. manage the SCD behaviour When you have finished to define the hierarchy a bind (to a...
Card Puncher Data Processing
OWB - Operators

The operators are used in a mapping to create a process and have several types : Source/Target Operators: These operators represent Oracle Database objects in the mapping. It also contains Flat File...

Share this page:
Follow us:
Task Runner