Oracle® Business Intelligence Applications Installation and Configuration Guide > Oracle Business Analytics Warehouse for Life Sciences Data Considerations >
Incremental Updates in the Oracle Business Analytics Warehouse LS Dimension Tables
This issue is specific to Oracle Business Analytics Warehouse for Life Sciences and does not affect other products. In the LS dimension tables the following incremental updates are supported. Some dimensions have more than one set of attributes. W_ALIGNMT_DH
Base Dimensional Hierarchy Table.
Attribute. Zip code, Brick, or Account/Contact Hierarchy depends on what alignment item type is selected.
NOTE: In release 7.9, all Zip Code, Brick and Account/Contact hierarchy alignment can be loaded.
Description. Contains the current version of alignment only.
W_ALIGNVER_DH
Slowly Changing Dimension Type.
Attribute. Historical Zip code, Brick, or Account/Contact Hierarchy depends on what alignment item type is selected.
NOTE: In release 7.9, all Zip Code, Brick and Account/Contact hierarchy alignment can be loaded.
Description. Tracks historical alignments. Note the following:
|