opbang

 Profile Answers by opbang 

• Sep 29th, 2006

 

In Datawarehousing,

Levels are columns available in dimension table. Levels are having attributes.

Hierarchies are used for navigational purpose, There are two types of Hierarchies. You can define hierarchies in top down or bottom up.

1. Natural Hierarchy : Best example is Time Dimension - Year, Month, Day etc. In natural Hierarchy definate relationship exists between each level

2. Navigational Hierarchy : You can have levels like

Ex - Production cost of Product,  Sales Cost of Product.

Ex - Lead Time defined to procure, Actual Procurement time, 

In this two levels need not to have relationship. This Hierarchy is created for navigational purpose

jyothi

• Feb 10th, 2007

 

Hierarchical level of datawarehousing is nothing but the concept of generalization and specialization.As we move up the hierarchy the data is more generalized for ex : the location where STATE is more genarilized for of locationAs we move down the hierarchy the data is more specializedfor ex : the location where STREET is more specialized data.