Home > Software > Tableau
Interview Questions   Tutorials   Discussions   Programs   Videos   Discussion   

Tableau - What is oltp and olap?




1017
views
asked Ramesshh November 1, 2014 10:07 AM  

What is oltp and olap?


           

1 Answers



 
answered By krishna-1064   0  

OLTP(ONLINT TRANSACTION PROCESS): 1.OLTP contain only current or live data 2.we can use oltp to analyse business 3.oltp contai limited history(1month,2month,3months) 4.oltp contain normalize data 5.used to run business 6.application oriented data 7.Detail data OLAP(ONLINE ANALYTICAL PROCESS)nothing but warehiusing: 1.OLAP contain unlimited history(8years.10years) 2.we can use olap date to take decisions on users 3.Olap contain denormalized data 4.Olap contai historical data 5.used to analyze business 6.ssubject oriented data 7.summarized data

flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  16 people following this tag

  Question tags

tableau × 16

Asked 3 years and 1 month ago ago
Number of Views -1017
Number of Answers -1
Last updated
3 years and 1 month ago ago

  Similar questions


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert