Star Transformation in Siebel Analytics (OBIEE)
Star Transformation is a join method mostly used in Data Warehousing Environments to fine tune typical query performance. It is of utmost importance in DB environments where reporting tools like Siebel Analytics (OBIEE) is in use. It can also be used for other tools such as Business Objects. The conventional join mechanisms that the star transformation seeks to supersede are Hash join, nested-loops and sort merge join.
This paper shows how to take full advantage of this RDBMS feature. Another myth it dispels is the fact that implementation of the Star Query is not possible without creating a physical primary key foreign key dependency between the fact and the dimension tables
All the necessary database parameters and other settings required for the set up of this feature have been highlighted in this paper. Parts of this paper which include the understanding of Star Transformation concept have been influenced by the paper Supercharging Star Transformations by Jeff Maresh in particular and various other Oracle resources mentioned in the References section
All the results in this paper were produced on Oracle 10.2.0.4 64 Bit
A white paper on this subject written by me is as below