<stage-dimension>

Fields from the data file are loaded into a dimension.

validate-against-data sources

Optional attribute applicable only for stagemaps. It has no effect for load specifications.

dimension

Required: Case-sensitive name of the dimension; for example, dimension="Product". Define how the data fields are mapped to dimension members in the <member> elements. because Release 3.1, filters can be defined at this level to filter the load records before being processed by the <member> elements.

Following is an example of a specification to load the Product dimension:

<delimited-file start-row="2" delimiter=",">
  <field index="1" name="product family"/>
  <field index="2" name="finished good"/>
</delimited-file>
 
<stage-dimension dimension="Product"> 
  <member hierarchy="Product"> 
     level="Product Family" 
     ns="Product" 
     parent="Product/Product/Product"> 
    <map attribute="name" value="${product family}"/> 
  </member> 
  <member hierarchy="Product"> 
     level="Model" 
     ns="Product" 
     parent="Product/Product/${product family}"> 
  <map attribute="name" value="${finished good}"/> 
  </member> 
</stage-dimension>

Note:

<prologue> | <epilogue> enable for custom code to be invoked before and after staging.