1.Diff between drill down and drill through?2. What is meant by roll-up?3.What is meant by external roll-up?How to create external rollup with example?4.What is meant by clean house command?5.What is meant...
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...
What is the difference between datawarehouse and bi?
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...
Can we have a commit statement inside a trigger? If no why cant we?
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...
BPO Career for BTech Graduates
How productive are you?
Do you seek advice from others when you have a question?
What are my options when I do not get a job after graduation?
What is the role of a mechanical engineer in the Software Industry?
Provide an example of a goal that you successfully attained.
What will you do when you are not able to get your message across to your audience?
Has there been a time when you were presented a problem and solved it?
What do you do when things do not go as planned? Cite an example.
How do you handle conflict?
Ask Interview Question?
Have Career Question?
Ask Only Career questions.