what is meant by roll up and roll back in dataware housing????
- 4 Answers
- 10824 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 |
What is RenderVariable?
Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
How can we find out cardinality between two tables?
Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!
What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.
What is Render Variable? where u can use?
What is cognos reporting tool?
what are ERP systems?
wt is the differnce between Block & conditional block ?
What do you understand by the term 'model durability'?
1)what is the use of Deployement and Scheduling? 2)If you have a prompt in your report , after scheduling the report will it run? 3)How can we move our reports from one Environment to Another Environment? 4)What is the complex report in your project and whar are the critical issues have u faced in u r reports and tell me name of some recent reports have u created? 5)What are the limitations of value prompts?
Teradata 
