what is meant by roll up and roll back in dataware housing????
Answer Posted / 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 |
Post New Answer View All Answers
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
Can you define a datastore in cognos?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
Give me any example of semi and non additive measures?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
What is a Cube?
What is called materialized view?
Write types of folders present in cognos?
1. Explain your project.
What is Metrics designer?
How to test a cube?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What is cognos connection?
What are the two types of framework manager?