Hi friends,
We are developing new application reports and the tool requires star schema in the Oracle database. It is still in starting phase so we are trying to gather information on this. I'm new to this so I have been reading a lot and researching on star schemas. I would like to get your inputs /suggestions from you experts as well. From what I'm reading it looks like star schema contains one fact table and can have multiple tables pointing
to the fact table as FK's.
One question is that are star schemas enabled at schema level or does it have to be at the database level by making star_transformation_enabled='TRUE' in the ini file.
Also, are there any other parameters to use star schemas or just star_transformation_enabled should be TRUE?
Thank you so much