How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...

Answers were Sorted based on User's Feedback



How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me.....

Answer / syamala

OLTP is current data .eg:ATM Transactions 
OLAP is historical data . it maintains history 

Is This Answer Correct ?    5 Yes 0 No

How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me.....

Answer / sasi

5 years data is olap .

where oltp  depends on the transactions it maintains the data 

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Cognos Interview Questions

What is meant by grouped star schema

0 Answers   IBM,


Can you define drill down and drill up?

0 Answers  


What is the enterprise class platform architecture of cognos 8?

0 Answers  


How can we migrate from Businees Objects reports to Cognos 8.x??

1 Answers  


Can you define report item?

0 Answers  






wt is scope relationship?

2 Answers  


what are the types of scheduling and what are the errors faced while scheduling then how to solve those errors?

1 Answers   Dr Reddys, TCS, Thomson Reuters,


-------------What is a Conformed Dimension?

3 Answers   Bank Of America,


Can you define a catalog and types of catalogs in cognos?

0 Answers  


What is Local Cache and how does it help in performance tuning

1 Answers  


After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate<fromdate its an error. How can we generate the user defined error message for this type of error

0 Answers   IBM,


How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?

5 Answers   CTS,


Categories