topic Re: Data Model converting from Snow flake to Star schema in QlikView

Data Model converting from Snow flake to Star schema

maheshkharade — Sat, 16 Nov 2024 05:09:40 GMT

I have a data model which is in Snow flake schema type. But I need to convert it in Star schema. The fact data tables are not related to each other. There is no attributes in common in measures(Fact) data. Which method I have to use?

Please help.

Re: Data Model converting from Snow flake to Star schema

PradeepReddy — Fri, 23 Nov 2018 02:13:10 GMT

try 'Link Table' concept

Re: Data Model converting from Snow flake to Star schema

prma7799 — Fri, 23 Nov 2018 04:25:22 GMT

Please check this

http://www.learnallbi.com/link-table-in-qlikview/

Re: Data Model converting from Snow flake to Star schema

its_anandrjs — Fri, 23 Nov 2018 07:05:36 GMT

Hi,

Try Link table concept or may be use Concatenation between tables with use of Flags to identify the table with its name.

Regards,

Anand

Re: Data Model converting from Snow flake to Star schema

maheshkharade — Fri, 23 Nov 2018 17:53:30 GMT

Thanks for sharing this link..