Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is the deployment requirements used in cognos?

1595


which type of project we r going to snowflake schema

1931


How Metrics Studio is better than Report Studio?

2510


Can you define a query subject?

976


What is drill down and slicing and dicing whats the difference between them?

990


What are the roles defined by cognos platform?

1074


Can you explain the advantage of using shortcuts?

986


Diff b/w Crossproduct and Outerjoin?

2219


What is the difference b/w macros and prompt?

1039


What are the advantages of cognos?

918


What are cognos connection initial page components?

1056


what is online view?

1890


-------------What is Coditional Prompting?

2072


What are the two types of framework manager?

1213


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.

2147