topic Re: name of the data model? in QlikView

name of the data model?

Wed, 29 Oct 2014 09:32:03 GMT

HI,

i have 7 tables here

table1 is FACT

table2

table3

table4

table5

table6

table7

table2,table3,table4,table5 is connected to fact like start schema and

table 6 is connected to table 7

finally fact table(t1) is surrounded by t2,t3,t4,t5

t6 connected t7

what is schema we can say here ?

if it is star every table need to connect with fact table(t1) but here t6,t7 is having separate relation ship ?

Wed, 29 Oct 2014 09:35:28 GMT

Hi,

It is called as a snow flake schema.here T6 is the parent table with connect T7 child table

dferreirogft — Wed, 29 Oct 2014 09:38:09 GMT

Hi,

It's called a snowflake model.

I will recommend to you to delete T7 concatenating/joining it to T6 to have a snowflake model so you will follow Qlik Guidelines.

Cheers

Dany

Wed, 29 Oct 2014 09:42:25 GMT

so finally if we have any other relationships not wth fact then we can say snowflake rigght

dferreirogft — Wed, 29 Oct 2014 11:00:12 GMT

Hi,

Yes, It will continue being an snowflake model with Data Island.