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

Most of the developers can't differentiate between ODS,Data warehouse, Data mart,OLTP systems and Data lakes.
This video explains what exactly is an ODS, how is it different from the other systems.
What are its properties that make it unique and if you have an ODS or a warehouse in your organisation
#ODS #OLAP #TechCoach

Commenti

  • Tech Coach
    Tech Coach

    Guys please support me in building my new youtube channel "An Indian Abroad " by watching subscribing and sharing with your friends it-stream.com/den-AnIndianAbroadd

    Anno fa
  • Narasimhan Murugan
    Narasimhan Murugan

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

    Mese fa
  • Laqurida Enamor
    Laqurida Enamor

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

    Mese fa
  • Trehnt
    Trehnt

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

    Mese fa
  • Trehnt
    Trehnt

    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?

    Mese fa
  • Tech Coach
    Tech Coach

    @Trehnt 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 :)

    Mese fa
  • Trehnt
    Trehnt

    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

    Mese fa
  • Tech Coach
    Tech Coach

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

    Mese fa
  • Harinee Mosur
    Harinee Mosur

    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.

    2 mesi fa
  • Tech Coach
    Tech Coach

    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.

    2 mesi fa
  • Velumani J
    Velumani J

    Nice explanation. Thanks for your time putting this together.

    4 mesi fa
  • Tech Coach
    Tech Coach

    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 it-stream.com/stream/video-j7RrxEnZ_8E.html

    4 mesi fa
  • ansh sachdeva
    ansh sachdeva

    very good explaination

    6 mesi fa
  • Sakshi Mittal
    Sakshi Mittal

    Please explain change data capture

    7 mesi fa
  • Tech Coach
    Tech Coach

    Sure Sakshi, I will work on it.

    7 mesi fa
  • Vijay Mech
    Vijay Mech

    I have a doubt ODS is normalized or denormalized data?

    9 mesi fa
  • sowmya v
    sowmya v

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

    11 mesi fa
  • samudhrala soumya
    samudhrala soumya

    Good explaination

    Anno fa
  • Tech Coach
    Tech Coach

    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. it-stream.com/stream/video-GnVn3mPBRz4.html

    8 mesi fa
  • Vijay Ajarla
    Vijay Ajarla

    Best video in IT-stream on ODS ,❤️

    Anno fa
  • Tech Coach
    Tech Coach

    Thanks Vijay for the kind words. I am working on this new channel and would really appreciate if you watch and subscribe to it. it-stream.com/stream/video-IP2Vn6jK8Hg.html

    Anno fa
  • Sa Si
    Sa Si

    thanks for the useful video

    Anno fa
  • Tech Coach
    Tech Coach

    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. it-stream.com/stream/video-11DK-oyRql0.html

    Anno fa
  • Jasleen Gill
    Jasleen Gill

    very useful

    Anno fa
  • Tech Coach
    Tech Coach

    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. it-stream.com/stream/video-HBQHekM1U2c.html

    Anno fa
  • An Indian Abroad
    An Indian Abroad

    Guys please support me in building my new youtube channel "An Indian Abroad " by watching subscribing and sharing with your friends it-stream.com/den-AnIndianAbroadd

    Anno fa
  • Sudhir Garg
    Sudhir Garg

    nice one

    2 anni fa
  • Tech Coach
    Tech Coach

    Thanks a lot Sudhir for the kind words :)

    2 anni fa