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
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
Diff b/w Crossproduct and Outerjoin?
How create measures and demensions?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
Define query items?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
How to create a cube in Transformer? What is the process? Please mention process thank u
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
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..
How do you improve the performance of the Cognos Analytics report
--------------Explain Table of contents?
What are the components used in web tier?
What is the function of cognos dispatcher?
what are slowly changing dimensions? Why we are used scd?
What are all the types of hierarchies?