topic Re: convert snowflake schema into star schema in QlikView

convert snowflake schema into star schema

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

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

marcus_malinow — Fri, 14 Dec 2018 13:29:40 GMT

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 — Fri, 14 Dec 2018 13:33:53 GMT

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 — Fri, 14 Dec 2018 13:34:08 GMT

Thank you Marcus