name of the data model?

[#1]

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  ?

[#2 · Accepted solution]

Hi,

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

[dferreirogft]

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

[#4]

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

[dferreirogft]

Hi,

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