Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by roll up and roll back in dataware housing????
- 4 Answers
- 12339 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 errors and types of errors you faced in Cognos ReportNet?
How can create users and permissions in cognos?
How to pass parameter value into html design page?
What you mean by drill across?
How do you test the reports? Explain the Unit testing procedures after developing the reports?
i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?
What are the differences between main Cognos 8.2 and 8.3 ?
suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?
Explain the Difference Between Bursting and Scheduling?
Is it possible to join multiple Databases in a Catalog?
What is slowely changing dimensions?why we are used SCD?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
Teradata 
