Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Could you please tell me how to convert snowflake schema to star schema without using join and concatenate?
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
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/
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
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/
Thank you Marcus