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
Answer / syamala
OLTP is current data .eg:ATM Transactions
OLAP is historical data . it maintains history
| Is This Answer Correct ? | 5 Yes | 0 No |
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 |
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
When we deploy the report to live the client get the data error how can we resolve that
what are the features in cognos8ui
what are slowly changing dimensions? Why we are used scd?
is there any difference between operational database and data base?if yes what r they?
What are the Macros?
What are types of batch available in cognos?
What is the use of 'individual data source' option while using filter in query studio?
How do we run stored procedure?
What you mean by drill across and what is the difference between drill through, drill across?
Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?
What are the different kinds of panes included in cognos?