Datawarehouse

Hi Listers,

I have a quick question about setting up a star schema datawarehouse using star_transformation_enabled. I have a fact table and several dimension tables. My fact table is a personal table and some of the dimension tables are grades and test scores. The fact table has the students id and it is linked to all of the dimension tables with the id field. To use the star transformation I need to have a bitmapped index on the id field in the personal table. This is going to be a totaly unique field.

The question is, what is the downside of a bitmapped index on such a field? Is my thought process correct that there needs to be a bitmaped index on this field to utilize the star transformation?

Thank You for any insight!

Joe

-- 


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

  Joe Frohne                        joe_at_rawsonoaks.com
  OCP Database Administrator        www.rawsonoaks.com


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-