Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by roll up and roll back in dataware housing????
- 4 Answers
- 12409 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 value prompt limitations while creating report? What is select and search prompt?
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?
------------ Diff b/w MemberCaption and MemberDescription?
What are the main services provided by application tier?
What is the use of cognos decision stream?
what is hints in cognos and where we use it.
what is cardinality that you can give to employee and department query subjects in framework manager?
What is Stich Query in Reportnet?
What is diffence between query calculation and layout calculation?
How to test reports in cagonos ?
10 Answers CST, CTS,
What is the difference between a data mart and a data warehouse?
Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!
Teradata 
