what is meant by roll up and roll back in dataware housing????
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
moving from month to year is rollup
i think there is no roll back in DW
|Is This Answer Correct ?||3 Yes||2 No|
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
|Is This Answer Correct ?||3 Yes||4 No|
What is set to be cardinality?
how to access the database directly from cognos reportnet
In how many ways we can apply the security to a cube in Transformer? Explain?
hi my name is siraj i want to know cognos queriy language
pls ans what are the filters we have in framework manager? filters in report studio?
what happens when date function has taken as attribute
what is the difference between a data item and a query item?
What is the use of Excel files in Cognos8?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
How to upgrade drivers in Cognos 8?
What is Crossproduct?
How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.