Dear All,
Snowflake vs star schema in obiee 12c RPD
Current scenario
Snowflake with 5 tables
Region category and country fetched through 3 tables snowflaked with the dimension customer.
through ETL we can load the country region and category information to the customer table and make it a star schema.
Can somebody help me to understand the advantages and disadvantages in terms of performance and other aspects. It would be a great help
