Normalization

[#1]

Hey guys,

I am a total newbie at QlikView. How do I go about normalizing signup_datetime, choice_datetime and option_like_datetime for all my tables as shown below?

Your help is much appreciated.

Thanks in advance,

Nat

[bgerchikov]

Hi Nat,

I guess your talking about denormalizing your data model. The simple way is a left join as follows:

Left Join(Option)

Load * Resident OptionLike;

Drop Table OptionLike;

Hope it will help

[#3]

Plz. go thru Snow Flake/Start Schema, Fact Tables, JOINs etc also attached the link which might be useful

Normalized vs deNormalized load