Skip to main content

Projection design

  • August 20, 2015
  • 3 replies
  • 16 views
Saurabh3297

I need to design the projection in such a way that the join between a fact table and multiple dimension tables simultaneously works fast. Pre-join projection is not an option as merge operation is happening during load of tables. Also co-segmenting and co-ordering can be done only for one pair of tables at a time. Please help.

    3 replies

    Adrian_Oprea_1
    Forum|alt.badge.img+1
    • Adrian_Oprea_1
    • Participating Frequently
    • August 21, 2015

      Take the query you are running and go thru the DBD using incremental option where you suply the DBD with your query.

      You will end up with some optimized projection for your query.

     

    Saurabh3297
    • Saurabh3297
    • Author
    • New Participant
    • August 21, 2015

    Hi Adrian,

     

    Thanks for your response. But what I intend to understand is the concept that would be applied to create a solution of this problem. Any explanation in this regard would be very helpful.

     

    Thanks

    FiliN
    Forum|alt.badge.img
    • FiliN
    • Participating Frequently
    • August 25, 2015

    Can't uderstand "Also co-segmenting and co-ordering can be done only for one pair of tables at a time." why?

    You can create multiple projection for each join operation. Did you try it?

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement