Projection design

Saurabh3297Saurabh3297
in General Discussion

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.

Comments

  • Adrian_Oprea_1Adrian_Oprea_1

      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.

     

  • Saurabh3297Saurabh3297

    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

  • FiliNFiliN

    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?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...