convert snowflake schema into star schema

[Anonymous]

Hi All,

Could you please tell me how to convert snowflake schema to star schema without using join and concatenate?

[marcus_malinow · Accepted solution]

Without seeing your data model it's difficult to say though I'd advise you overcome your aversion to Joins and concatenations

One alternative may be to move keys from snowflaked tables to your fact table

Another may be to use Applymap to move fields from snowflaked tables to star schema dimensions

[Colin-Albert · Accepted solution]

Perhaps by using mapping tables and applymap to move data from the outer levels of your model nearer to the fact table.

Try these blogs for more info

Don't join use applymap
https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

Applymap Is it so wrong
https://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

[Anonymous]

Thank you Marcus