Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
Swathi
Not applicable

convert snowflake schema into star schema

Hi All,

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

2 Solutions

Accepted Solutions
marcus_malinow
Not applicable

Re: convert snowflake schema into star schema

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
Not applicable

Re: convert snowflake schema into star schema

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/

3 Replies
marcus_malinow
Not applicable

Re: convert snowflake schema into star schema

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
Not applicable

Re: convert snowflake schema into star schema

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/

Swathi
Not applicable

Re: convert snowflake schema into star schema

Thank you Marcus