Data model keys

[#1]

Hi folks!

This is a first post from a newbie so please be gentle!

I would like to pick your brain on keys in a QlikView data model.

Primary key - is unique for each record in a table. Subset ratio is less than 100% always?

Perfect Key - is a primary key with subset ratio of 100% always?

Key - is non-unique with a subset ratio of 100% or less?

I can't currently think of any more keys. Any help would be much appreciated.

Nish

[maheshkuttappa]

You could refer below links for details ,

[Perfect Key]?

What is Perfect Key & Information Density?

[#3]

Hi Mahesh,

Thanks for your reply.

I'm familiar with the details on the links you have provided. Basically, I am looking for a yes/no type answer to my questions to re-assure that my understanding of this concept is legit - that's all.

Nish