sangroover

• Feb 15th, 2006

 

B is the correct answer.

noel gaur

• Jul 9th, 2006

 

A,B,C are correct and not 2 of the above coz

a) A hierarchy can consist of multiple levels(level based hierarchy)

b) A hierarchy can consist of multiple levels( for eg snow flake schema dimensions r 3rd normalized based on two or more tables)

c) A dimension can contain only a single hierarchy. this is a normal case as we normally during dimension load choose one defalt hierarchy. no matter how much hierarchy it has in the case of Oracle AWM at a time dimension members and attributes for only one hierarchy is loaded.

d) as we all know that privilages r must.