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


Please Help Members By Posting Answers For Below Questions

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1533


Explain is there any comparison available for cognos reportnet vs crystal reports?

550


4. How many dimensions did you use in your reports?

1494


Why cognos decision stream is used?

642


What is cognos powerhouse?

588






What is the use of report studio?

615


What do you understand by the term 'model durability'?

570


Can you define drill across?

566


What you mean by drill across and what is the difference between drill through, drill across?

555


What is a Datastore in Cognos?

805


What is main difference mapplets and mapping?

574


what are the errors faced while bursting the reports and how to solve those errors?

1571


How to deploy from one server to another server?

2024


write a query to display the departments with no employee?

1557


What is the difference between the content store and content manager?

574