Star transformation can be really useful in DW environments, where you have your tables divide into dimensions and facts. And the most important, you need to have bitmap indexes!
To implement it, you need to change the star_transformation_enabled for your user session and create the tables and indexes to play.
Try to practice creating one fact table and 3 dimensions. Later, create a bitmap join and check the plans with the three compatible values for STAR_TRANSFORMATION_ENABLED = { FALSE | TRUE | TEMP_DISABLE }.
Path to Documentation:
Data Warehousing Guide -> 20 Schema Modeling Techniques
Data Warehousing Guide -> 7 Indexes
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
