tell which schema it is ?

[Anonymous]

Hi , pls give name for each picture under which schema it follows

[Peter_Cammaert]

1. Snowflake

2. Star (messed up)

3. Star

That is, if each time the central table is your single Facts table.

Best,

Peter

[Anonymous]

star (messedup) means what

[Anonymous]

PNG1  Star Schema

PNG3 Star Schema with data Island

PMG2 Star Schema with two fact tables .. Fact to Fact joins are not recommended to you can create two star schema for that.

[datanibbler]

Hi,

I guess, judging by the pictture, Peter means that you have a "data_island" (that is, a table - the calendar - which is not linked to any other. That makes the performance of the app worse - plus you cannot use fields from that table, e.g. as dimensions. It works - sometimes data_islands just cannot be helped, I have some in my apps, too - but if possible it should be avoided.

HTH

Best regards,

DataNibbler

[#6]

Hi,

All there are Star Schema as balkumarchandel said second one is Star Schema with data Island

[engishfaque]

Dear CommonQlik,

Snowflake schema and star schema,

dm2.png => Snowflake Schema

Attachment dim3.png => Star Schema

Attachment data model1.png => Star Schema

Listed below image will help you to understand the schemas.

Kind regards,

Ishfaque Ahmed

[#8]

Hi all are Star Schemas ............

[Anonymous]

Hi all,

i feel guilty because every one is working on qlikview , but there are many queries buy identifying the schema name it self.