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.