Post reply

Why We Use ODS ? / What are its Advantage ?

  • August 18, 2008 at 9:34 am

    #196515

    Hi All,

    Can u please help me to find solution for question Why We Use ODS ? / What are its Advantage ?

    Is it necessary to use ODS as an middle layer between production server (OLTP) and Data Warehouse.

    Thanks

  • August 18, 2008 at 3:39 pm

    #859709

    Hi,

    ODS (Operational Data Store) are sometimes needed if the source database can not be accessed directly. An ODS also allows you to offload reporting to a 'non-production' datasource, therefore reducing potential bottlenecks on your production databases. I am sure there are more reasons but these two are the reasons why we employ ODS.

    Hope this helps,

    Ralph Schwehr

    DBA

  • August 20, 2008 at 4:11 pm

    #860927

    The ODS can also prevent problem related to the data changing while you build your dimensions and fact(s) since the ODS should be static at that time.

    ODS also provides a means of filtering or scrubbing data.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • August 23, 2008 at 5:57 pm

    #862267

    Hi

    Thanks for all of urs response

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply