ODS database (Operation data Store ), Its properties and purpose explained with examples

[@TechCoach]

Guys please support me in building my new youtube channel "An Indian Abroad " by watching subscribing and sharing with your friends
ruclips.net/user/AnIndianAbroadd

[@dineshkalva3884]

Great video. As you said in video, could you please share video difference between ODS, Datamart, Datalake and datawarehouse

[@chalamaiely]

Uiuuiiuipjijppjpiopuiu

[@keepcalmuvlb5n]

Best video in RUclips on ODS ,❤️

[@TechCoach]

Thanks Vijay for the kind words. I am working on this new channel and would really appreciate if you watch and subscribe to it.
ruclips.net/video/IP2Vn6jK8Hg/видео.html

[@shazms6683]

This video was very informative and it is explained in an easy way.
Thanks for this video.

[@jyotimakonati965]

Thanks Sir for your great explaination on datawarehouse n all concepts

[@TechCoach]

Thanks Jyotima for the kind words :)
Please consider subscribing to my other channel as well. It will really help me.
ruclips.net/video/6G1xGi-D5ow/видео.html

[@dsharma8198]

Excellent video on ODS

[@TechCoach]

I am glad I could help :)

[@suryar3803]

I came across your channel only today and found them very clear, crisp and easy to understand. Very great examples you have chosen to explain concepts. Good job vivek! Way to go

[@TechCoach]

Thanks a lot Surya for the kind words :)

[@vijaykotagiri6452]

Excellent video to understand the ODS and Dataware house.

[@TechCoach]

Thanks Vijay , I am glad you enjoyed it :)

[@NripaEmpowerthroughknowledge]

Thanks for the session. ,

[@TechCoach]

Thanks Buddy

[@Richtube33]

Clear and concise. Nice job 👍

[@TechCoach]

Thanks a lot for the kind words :)

[@shaikh340]

Thank you for clear and concise explanation. My question is How is ODS is different than OLTP?

[@jebarajantoni7531]

Such a beautiful explanation bro

[@TechCoach]

Thanks a lot buddy :)

[@ericsos101]

awesome video, but what i am missing it that you did not show how to move your data from staging to ODS? did you use SCD 1 and if yes how did you do it? thanks

[@TechCoach]

Thanks Eric we did maintain latest versions,so yes we implemented scd1 using an ETL tool.

[@ericsos101]

@@TechCoach okay and how did u do that, u did not show here

[@chanchalyadav3671]

Very useful

[@TechCoach]

Thanks a lot Chanchal for the kind words :)

[@galeop]

Great explanations!

[@TechCoach]

I am glad I could help :)

[@varshapathak3427]

Great Explaination Sir!! Could you please demonstrate a small procedure /program for data load in ods and maintaining historical data (audits)

[@ProdbyTrehnt]

I'm so confused, yet so determined to learn at the same time. I plan on coming back to this 😂👍

[@TechCoach]

For sure , If I can be of any help please do let me know :)

[@ProdbyTrehnt]

Tech Coach thanks, I just graduated school with a. BA degreee but realized I’m really interested in BI. So trying to learn programming lol

[@TechCoach]

@@ProdbyTrehnt Start with a good course on excel, follow it with a good course on sql and then a dashboarding tool like tableau or powerbi. All the best :)

[@ProdbyTrehnt]

Tech Coach I took a CIS class that showed us a lot of fundamentals with excel, tableau and R but I’m looking to take it to the next step... I don’t know if I should study more to go into an entry level data position or BI internship?

[@narasimhanmurugan5448]

Hi thanks for knowledge adding video. please tell what is constant refresh and trekel loading.

[@anshsachdeva1061]

very good explaination

[@samudhralasoumya9520]

Good explaination

[@TechCoach]

Thanks Samudhrala for the kind words I have a small request
I am working on this new youtube channel, I Would love it if you watch and subscribe to it as well.
ruclips.net/video/GnVn3mPBRz4/видео.html

[@VartikaRamnani]

nice

[@TechCoach]

Thanks buddy :)

[@velumanij3996]

Nice explanation. Thanks for your time putting this together.

[@TechCoach]

Thanks Velumani for the kind words, I have a small request.I am working on this new channel and will really appreciate if you watch and subscribe to it
ruclips.net/video/j7RrxEnZ_8E/видео.html

[@vijaymech8474]

I have a doubt ODS is normalized or denormalized data?

[@samarth1655]

Can you compile a video on ODS vs Staging Table? or suggest the source to understand the difference.

[@TechCoach]

Staging tables have raw data from source system while ODS data is much more structured for reporting or downstream application purposes

[@harineemosur6530]

Thanks This is very good. We are having ODS implementation in hadoop and I am not clear on the Master/Transaction partition concept, can you please direct me to some sources to understand this better and in general ODS.

[@TechCoach]

The basic partition and segmentation strategy should be simple . Segment the facts and replicate the small dimensions among nodes. Segmentation should be done to distribute fact data evenly between nodes and then we can further partition the data based on our data usage strategy ( Joins).
The idea is to minimize network traffic among nodes for query execution.

[@sasaf6988]

thanks for the useful video

[@TechCoach]

Thanks for the kind words,I have a small request I am working on this new channel "An Indian abroad" and will really appreciate if you watch and subscribe to it.
ruclips.net/video/11DK-oyRql0/видео.html

[@sowmyav6003]

Could you please tell the data flow process in ods ??

[@amitmav8983]

Best one I came across. Is there any way I can reach you by email or phone?

[@TechCoach]

Hi amit , you can reach out to [e-mail]

[@amitmav8983]

@@TechCoach Thank you. I have sent you the email.

[@meditation_in_nature]

nice one

[@TechCoach]

Thanks a lot Sudhir for the kind words :)

[@vijaykotagiri6452]

Could you please post a video on ELT, Datalake as well. Thank you Vivek for your videos.Very useful to ETL resources/beginers.

[@TechCoach]

Sure Vijay, I have noted it down in my list,I will upload the video soon

[@VivekKumar-yy8ie]

The one thing that ODS's are use frequently in any Enterprise is Ad-hoc reporting..

[@sakshi13101991]

Please explain change data capture

[@TechCoach]

Sure Sakshi, I will work on it.

[@jazzuk93]

very useful

[@TechCoach]

Thanks for the kind words Jasleen.
I have a small request I am working on this new youtube channel "An Indian Abroad" ,it will really help me if you watch and subscribe to it.
ruclips.net/video/HBQHekM1U2c/видео.html