Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by roll up and roll back in dataware housing????
- 4 Answers
- 12633 Views
- Covansys, IBM, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
-----------Diff b/w OLAP and RDBMS?
What are the components required for the application tier?
How to improve the performance of the report at the report level?
How is cognos model organization works?
what are the dimensions that you have in your current project?list them?
can we put more measure on cross tab? If so how many? How this affect the aggregation?
What is meant by drill down?
In an existiing Framework model, how will you add a new column to the existing table?
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
Interval Prompt's Usage? Example for usage in Project
What is the difference between set functions and filter function in dimensional data?
how can you create a report like if country=india then true if contry=spain then false?
Teradata 
