Answer to Qn. 4.
Cleanhouse command removes all the categories generated during the cube build.

Drill down is like in time dimension from year to qtr to month to week etc., In drill through you cannot only drill down in a single dimension but you can go to the next dimension as well.EG take 3 di...

dear,   according to my knowledge...Business intelligence: business intelligence is a group application which is used to gather information, providing access to, analyze the information and ...

To make Business Analysis effective and efficient we require specialized form of storage. This special form of storage of data is called Data Warehouse and the process DataWarehousing.Business Intelli...

We cannot use a commit statement in a trigger. Trigger has auto commit.

yes, here is an exampleSQL> CREATE OR REPLACE TRIGGER tab1_trig  2    AFTER insert ON tab1  3  DECLARE  4    PRAGMA AUTONOMOUS_TRANSACTION;  5...