what is meant by roll up and roll back in dataware housing????
Answer Posted / 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 |
Post New Answer View All Answers
What is the deployment requirements used in cognos?
which type of project we r going to snowflake schema
How Metrics Studio is better than Report Studio?
Can you define a query subject?
What is drill down and slicing and dicing whats the difference between them?
What are the roles defined by cognos platform?
Can you explain the advantage of using shortcuts?
Diff b/w Crossproduct and Outerjoin?
What is the difference b/w macros and prompt?
What are the advantages of cognos?
What are cognos connection initial page components?
what is online view?
-------------What is Coditional Prompting?
What are the two types of framework manager?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.