Skip to Content
author's profile photo Former Member
Former Member

Partitions on ODS

Hi everbody,

I Hope and pray everyone is good and doing well. Could anyone tell me is it possible to Make partitions on ODS like cubes. Be frankly speaking, i don't have much knoweldge on Partitions, please let me know the main purposes and usage and handling of those. I am very thankful and appreciate to who will give peachy replies. Have a nice day



Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Sep 05, 2005 at 02:00 PM


    The purpose is simple it is easier and faster to search in partitions. I thik Roberto has already given the way to partion ODS.

    with regards


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 05, 2005 at 01:55 PM

    Hi dear!

    sure,you can partition Active Data table...

    look here for more details...

    Hope it helps!



    (please, then reward the's THE way to say thanks here!)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2005 at 07:14 PM

    Partitioning an ODS is done for two reasons -

    1) to improve query performance by allowing the DB to ignore portions of the table that are not relevant, e.g. you partition an ODS on 0FISCYEAR because almost all queries only ever look at one year.

    2) to ease data administration burdens when dealing with large tables, e.g. you want to archive off data that is more than 4 years old. The archive process can simply drop partitions rather than having to run delete query.

    ODS design does not use partitions to improve loading as the cubes do. Instead it has a separate table that new data is loaded to, and which is then subsequently inserted/updated to the Activated table during the Activation process.

    InfoCubes - the F fact table is partitioned to faciliates the loading of data. The E fact table could be partitioned on 0CALMONTH or 0FISCPER (these are currently the only options for cubes), and would be partitioned for the same reasons mentioned above.

    Cubes can be partitioned from within the BW Admin Workbench (cube MUST be empty). A DBA must perform partitioning of an ODS.

    Before considering partitioing an ODS, yo uwould want to now about the ODS size, what queries exist, how they are restricted/filtered, etc. Typically, an ODS is partitioned on a time characteristic, e.g 0FISCYEAR, or 0FISCPER, but could also be partitioned on something like Business Area, or could even be partitioned on 0FISCYEAR then Business Area. The queries really drive that decision. Not going to try to explain all the options, that's really something to review with your DBA.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.