what is meant by roll up and roll back in dataware housing????

Question Posted / sendtoajaykumar

4 Answers
12257 Views
Covansys, IBM, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is meant by roll up and roll back in dataware housing????..

Answer / scaant

roll up means going from lowlevel concepts to high level
concepts and drill down(roll back) means going top to
bottom in concept hierarchies

Is This Answer Correct ?

6 Yes

3 No

what is meant by roll up and roll back in dataware housing????..

Answer / ajay

roll up means moving up one level in the specified
hierarecy.,ex:time dimension
year-quarter-month-day
moving from month to year is rollup

i think there is no roll back in DW

Is This Answer Correct ?

3 Yes

2 No

what is meant by roll up and roll back in dataware housing????..

Answer / thanjairajan@gmail.com

Roll Up: A method used to summarize measure values up the category tree structure.

Roll Back: I think this method is available only in oracle. roll back retrieve all records after delete the records from table.
for example if the emp table contain 100 records. delete these 100 records using delete command like *delete from emp* we can also retrieve all these 100 records using roll back method.

Is This Answer Correct ?

0 Yes

0 No

what is meant by roll up and roll back in dataware housing????..

Answer / veeru

There is rollback in DW.For example when you delete some
thing from any one of your table from your data base before
commit you can get back your deleted information by using
rollback.

Is This Answer Correct ?

3 Yes

4 No

Post New Answer