topic Re: Normalized & De-Normalized in QlikView

Normalized & De-Normalized

Sat, 18 Jul 2015 07:58:15 GMT

Hi Friends,

What is the difference between Normalized and De-Normalized ?? Can you provide any example or Document for this?

Thank you,

SatishRaj

Re: Normalized & De-Normalized

marcus_sommer — Sat, 18 Jul 2015 08:10:12 GMT

For qlikview Denormalization - Wikipedia, the free encyclopedia and Database normalization - Wikipedia, the free encyclopedia have nearly no meaning. To start building datamodels in qlikview, see:

Get started with developing qlik datamodels

- Marcus

Re: Normalized & De-Normalized

Sat, 18 Jul 2015 22:58:50 GMT

Normalized:

See the Snowflake Schema, where a dimension data is separated and kept in another table. For Example: Country, State, District, Post Code data are kept in 4 separate tables.

De Normalized:

See star Schema, where data is kept in one dimension table and that is directly joined to Fact. So in above case, Country, State, District, Post Code if you keep in one dimension table called Geographical table then It is De normalized. Here you will see data redundancy for country column, state column, District column because there may be 100 distinct Post code in a district and that district belongs to a State, country.