Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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



More Cognos Interview Questions

What is set to be cardinality?

0 Answers  


how to access the database directly from cognos reportnet

2 Answers  


In how many ways we can apply the security to a cube in Transformer? Explain?

1 Answers   Wipro,


hi my name is siraj i want to know cognos queriy language

0 Answers  


pls ans what are the filters we have in framework manager? filters in report studio?

3 Answers   IBM,






what happens when date function has taken as attribute

1 Answers   TCS,


what is the difference between a data item and a query item?

2 Answers   Bodhtree, HP,


What is the use of Excel files in Cognos8?

1 Answers  


how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

0 Answers   IBM,


How to upgrade drivers in Cognos 8?

1 Answers  


What is Crossproduct?

2 Answers  


How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.

2 Answers   Satyam,






Categories