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
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 |
How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?
7 Answers Genpact, iFlex, TCS,
What are the ways to import data into catalog?
What is meant by drill down?
what is the use of layout component reference
Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.
Write various indexes used in cognos?
What is the use of powerplay web viewer in cognos?
How applying "Level Span" in Cognos 8.3?
what is the difference between enterprise data warehouse and data warehouse
wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container
how you migrate reports to cognos 8 from previous versions?
What is dtm?