Hi Selva, Sure, will forward the topic to the respective team and will upload the video soon. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss that video from us.
👋 Guys everyday we upload high quality in depth tutorial on your requested topic/technology so kindly SUBSCRIBE to our channel 👉 ( bit.ly/Intellipaat ) & also share with your connections on social media to help them grow in their career. 🙂
As far as my understanding goes, Data Warehouse will support OLAP data. The reason is OLAP data(i.e aggregated data(in Lyman terms numbered data) )will assist end-users to make business decisions. If OLTP data(in Lyman term Raw Data) is integrated into DWH then the staging layer will be of no use and the target tables in the EDWH will increase in size and data retrieval for Reports/Dashboard will also be time taking.
at 9:49 it says that OLTP is faster compared to OLAP but isn't it supposed that the advantage of using OLAP is because you can do queries faster than OLTP ? so how is OLTP going to be faster ?
With OLTP, you will be processing lots of short online transactions like check your bank account balance, make an online check deposit with your phone, make atm withdrawals & deposits etc...these are short & fast transactions. But for OLAP, you will be given access to a database that contains as large as petabytes of data, you essentially download it & run queries (like simple excel to sort, separate, add different culums/rolls etc) against it. You might even API something like AWS Athena to it in form of big data analysis - all these take time.
Good video but you say "right" ... a lot.. its really noticeable when you listen at 1.5x speed .... right .... right .... right sorry for being critical, I wanted to let you know, not trying to be negative, the material was great.
It's already in archive...it's just content you store in glacier s3, tapes, sata slowest performing disks you can just run query against. It is not being updated with new data or transactions bcos it's already being stored for historical analysis.
Guys, what else do you want to learn from Intellipaat? Comment down below and let us know so we can create more such tutorials for you.
Nexus simulation, CISCO ACI Integration
Design thinking
Spring boot and micro services
Teradata
Hi Selva, Sure, will forward the topic to the respective team and will upload the video soon. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss that video from us.
👋 Guys everyday we upload high quality in depth tutorial on your requested topic/technology so kindly SUBSCRIBE to our channel 👉 ( bit.ly/Intellipaat ) & also share with your connections on social media to help them grow in their career. 🙂
As far as my understanding goes, Data Warehouse will support OLAP data. The reason is OLAP data(i.e aggregated data(in Lyman terms numbered data) )will assist end-users to make business decisions.
If OLTP data(in Lyman term Raw Data) is integrated into DWH then the staging layer will be of no use and the target tables in the EDWH will increase in size and data retrieval for Reports/Dashboard will also be time taking.
a great video! explaining the difference between OLAP and OLTP in such a comprehensive way with good real life examples! thank you!
Glad it was helpful!
Amazing explanation and presentation is perfectly done with the concepts.
Thanks a lot. :) Keep learning with Intellipaat. :)
Please continue to do such wonderful tutorials.Hope intellipaat beats unacademy one day.
Hahaha, Please stay tuned to Intellipaat for more tutorials😊
again, coming in clutch the day before my exam. Thanks a lot
All the best
Superb sir tqsm ur teaching is just awsm😊✨
Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Great video and nice narration. I liked the animations around the main content, but at sometimes they are a kind of distracting. Best wishes
Thanks for the feedback. :)
OLAP is an example of datawarehouse.
Yes
Each one has its own importance so both are usefull
The explanation is perfect ...But with the word "Right" after every sentence makes it really irritating
Thanks for the feedback Fernandes😊
Very nice, informativde and concicely summarised video
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Amazing video Sir! Thank you very much for the clear explanations with real life examples!
excellent video, explained with real time examples. Understood very well.
Glad you liked it! Keep learning with Intellipaat😊
An amazing narration with a great vedio...very informative..
Glad you liked it! Keep learning with Intellipaat😊
Nice. Thank you for this. 👍🏽
Thank you for watching. :)
at 9:49 it says that OLTP is faster compared to OLAP but isn't it supposed that the advantage of using OLAP is because you can do queries faster than OLTP ? so how is OLTP going to be faster ?
With OLTP, you will be processing lots of short online transactions like check your bank account balance, make an online check deposit with your phone, make atm withdrawals & deposits etc...these are short & fast transactions.
But for OLAP, you will be given access to a database that contains as large as petabytes of data, you essentially download it & run queries (like simple excel to sort, separate, add different culums/rolls etc) against it. You might even API something like AWS Athena to it in form of big data analysis - all these take time.
Good video but you say "right" ... a lot.. its really noticeable when you listen at 1.5x speed
.... right
.... right
.... right
sorry for being critical, I wanted to let you know, not trying to be negative, the material was great.
Fantastic!
@Prem Kumar Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Option 3 am I right . I am waiting for your reply.
@KIRTI SAHU We appreciate your active participation😊. Do like, share & subscribe to our channel to get updates on upcoming videos.
Please upload spring boot and micro services full series tutorials.
Hi Akash, please watch this: ruclips.net/video/y0Z1qFvfzTs/видео.html
May be it is OLAP why because we use OLAP in the Data mining process like a OLAP SERVER at middle layer
Please telle that it is right or weong
You say RIGHT A LOT
Apologies for the inconvenience
@@Intellipaat it's okay buddy but ur video was great. Loved the way u explained.
@@Intellipaat It is actually something good. Most smart people do same. Ever watch an interview of Elon Musk?
thank you for this helpful information, I really like the presentation
Glad it was helpful!
Very clear explanation for me, thx bro
Glad it helped
I think the answer will be OLAP
We appreciate your active participation😊. Subscribe to Intellipaat to know the right answer.
DW supports OLAP where as OLTP follows traditional RDBMS system
Okay😊
right
cool.
What are the success stories of one and the other? Any examples?
both are used for a different purpose. Please watch full video.
OLAP uses data warehousing
Okay😊
How the million records is transferred from source to target in ETL informatica..?
options 3 because OLTP, and OLAP both use data.
cool.
Option 3
I hate word “right” after that, but thank you for your task
very distracting right? :P
bc 😆🙆🏿♂️
Yeah, right?
Datawarehouse is the example of OLAP SYSTEM. So OLAP is the option
@padhu jangam Do like, share & subscribe to our channel to get updates on upcoming videos.
Thank you❤nice explain
Glad it was helpful!
Right ?!
Yes Ali Mustafa😊
Can u cover sas topics pls
Sure. Noted. Will upload soon. 🙂
Option3
@KIRTI SAHU We appreciate your active participation😊. Do like, share & subscribe to our channel to get updates on upcoming videos.
amazing accent
option 3
ok
thanks
@LAPOVETS Keep watching and subscribe to our channel to get more interesting videos
"Right"
👍
Do like, share & subscribe to our channel to get updates on upcoming videos.
OLAP
We appreciate your active participation😊. Subscribe to Intellipaat to know the right answer.
thanks you
Why Backup is not need for OLAP?
It's already in archive...it's just content you store in glacier s3, tapes, sata slowest performing disks you can just run query against. It is not being updated with new data or transactions bcos it's already being stored for historical analysis.
any help on MDX?
Hi, what help you want?
OLAP uses data warehouse
Okay😊
Right!!!
Data warehousing uses OLAP
If you wish to get Personal support Kindly call our advisors on IND : +91-7022374614 US : 1-800-216-8930 (Toll Free).
@@Intellipaat hahahahahhaha
Olap
olap
Integrated?
sorry?
both
Okay😊
nhii ree dosttttt
2
cool.
u down with OLTP? Yeah u know me
right. :)
OLTP
cool.
I really wanted to watch the whole video. But i couldn't stand the tonation and accent. sorry
Thanks for the feedback, will improve on that. :)
he did a fine job explaining, i understood it clearly
OLAP
Cool.:)
2
Olap
Okay😊
OLAP
cool.
It's the right answer data warehouse cannot support oltp as it has day to day transaction and doesn't store historical data