How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...
Answer Posted / syamala
OLTP is current data .eg:ATM Transactions
OLAP is historical data . it maintains history
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
--------------Diff b/w ODS and OLAP?
Can you define bitmap index?
what is stitch query in reportnet?
Can you define confirmed dimension?
what are slowly changing dimensions? Why we are used scd?
What is the metric store database?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What do you understand by ‘ibm predictive maintenance and quality’?
4. How many dimensions did you use in your reports?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
What errors and types of errors you faced in Cognos ReportNet?
What are shortcuts? Where it can be used? What are the advantages?
whats the difference between previous version of cognos and cognos 8 BI?