Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by roll up and roll back in dataware housing????
- 4 Answers
- 12469 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 |
In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?
What junk dimension contains?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.
which difficult you faced in your project?
A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt
can anybody tell me..how to enter with fake exp..wt r all the documents to carry while attending the interview..how to answer that i am working in..
how you provide security to reports? How you provide security to packages ?
What are various types of gateways in cognos?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.
What are all the types of hierarchies?
Teradata 
