Projection design

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.

Adrian_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.

 

Saurabh3297

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

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?