Hello All, Can anyone suggest me which one is better between star schema and snowflake schema in Anaplan? I don't have much knowledge regarding both of these comparisons. Please suggest to me.
In Anaplan, we don't refer to the Star or Snowflake schema, because these 2 schemas utilize the concept of a central Fact Table.
Instead we refer to the DISCO methodology https://community.anaplan.com/t5/Best-Practices/PLANS-This-Is-How-We-Model/ta-p/33530 , you can say the DISCO is like an enhanced Snowflake, it's enhanced because Anaplan stores transactional data where seen fit, and there could even be relationships between the multiple transactional data modules where seen fit.
However the common point i see between Star/Snowflake schema and DISCO is that Anaplan needs master data (aka List in Anaplan) to be populated first before the transactional data.
With the Snowflake model, dimension analysis is easier. For example, “How many accounts or campaigns are online for a given advertiser?”
The Star schema model is useful for metrics analysis, such as “What is the revenue for a given customer?
Snowflake schemas offer the following benefits compared to normal star schemas:
Benefits of Star Schemas
Star schemas offer the following benefits:
I would go with Start schema, Want to know detailed information about Star Schema, Check this post.