Posted by : Arjun Lagisetty Thursday, April 7, 2016

Bitmap indexes and star transformation of the BI queries play a critical role in achieving effective performance for dimensionally modeled database. So  a  BI/ETL Developer its important to understand the concepts of the Star transformation and the use of bit map indexes in this blog post.
There is plenty of good work being done on the public web with respect to these concepts. Instead of rehashing, I will point you to some very good resources. Though this may be common knowledge for someone coming from a old school Oracle Datawarehousing world. May ODI developers are plunge into Data warehouse development without any exposure to data warehousing principles or Oracle database related knowledge. This blogpost will be a good starting point for them.

What are bitmap indexes and what role do they play in data warehouse and some best practices?
Something to look out for
Bitmap Index on Single Table
Bitmap Index for Join!
https://docs.oracle.com/cd/B28359_01/server.111/b28313/indexes.htm


This following blog post will help you understand what star transformation is and how bitmap indexes are used in star transformations.
https://blogs.oracle.com/optimizer/entry/star_transformation


Leave a Reply

Subscribe to Posts | Subscribe to Comments

Popular Post

Labels

Blog Archive

Copyright © ODI Pundits - Oracle Data Integrator - Maintained by Arjun Lagisetty