Post reply

Cubes architecuture

  • March 6, 2009 at 9:31 am

    #384088

    Hi,

    I'm doing a DWH for retailers.

    i have rep. Type and status in my product dimension, which is rapidly changing. by any chance may i include that in my fact table. so that every time i don't have to go to product table to pull the information. in many of my reports i filter records through rep.type and status.

    Thanks,

    Regards

    Vij

  • March 9, 2009 at 8:23 am

    #956040

    I would say it really depends on how large your product table is compared to your fact tables. If you're going to be adding 2 columns, one of which sounds narrow (status) the other wide (type), to a table with millions or billions of rows, to save having to access a table with hundreds or thousands, it's probably not a great idea. But why not try it in your development environment and see how it works?


    Rick Todd

  • March 9, 2009 at 8:30 pm

    #956518

    Hi Rodd,

    thanks for your info.

    wil try to do the same.

    regards

    viji

  • March 9, 2009 at 9:55 pm

    #956554

    Hi Rick Todd,

    thanks for your suggestions.

    wil try to do the same.

    regards

    viji

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

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