Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
MVP & Luminary
MVP & Luminary

Re: How much memory uses a null value in a table?

Hi Jose,

I think you might be using the term "snowflake" loosely... Snowflake, strictly speaking, requires a single Fact and a number of Dimensions, when some of the Dimensions are linked to other Dimensions and not to the Star.

For example: Fact table contains Sales data. Dimensions: Customer, Product, Supplier, SalesPerson.

In a Star model, all 4 dimensions should be linked to the Fact. In a Snowflake, Supplier might be linked to Products and SalesPerson might be linked to Customer. Both models are valid. If the original data is organized closer to the latter option, then you need to add some data modelling logic to bring it to the Star format. That's the extra effort that may be necessary or may be unnecessary - depending on your preference.

What you described as a "snowflake" sounds like an Entity-Relationship model that's coming straight from a transnational system. That's not what we usually call "snowflake".

These different models are described very well in my book QlikView Your Business - check it out!..

cheers,

Oleg Troyansky

jmvilaplanap
Valued Contributor

Re: How much memory uses a null value in a table?

Thanks Oleg

You're right I was using the term "snowflake" in a non correct way.

I was speaking about models with more than a Fact Table and linked tables in between.

By the way, this book looks good, have several topic I'm interested in.

Regards