How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...
- 2 Answers
- 6117 Views
- HCL, IBM, I also Faced
- E-Mail Answers
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 |
---------------Tell me about DWH Concepts?
Explain how data modeling is useful to cognos in daily life?
In an existiing Framework model, how will you add a new column to the existing table?
how can you get the errors in job? when loops are araised we get error?
difference between boxtype and visiable
What is a Datastore in Cognos?
What is a dashboard in Cognos Report Studio and how do we creae it
Wt is the Diff between Business Key & member caption?
In framework Manager, what is a stitch query and is it good or bad?
what is the difference between group and association?
I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.
What is the difference between macro & Parameter
Teradata 
