topic Re: What is Generic keys in QlikView

What is Generic keys

NavinReddy — Fri, 12 Jul 2013 08:44:37 GMT

Hi All,

What is Generic keys and how it will create

How should we impliments this and where should we apply this

could some one help me

Thanks in Advance

Niranjan

NavinReddy — Fri, 12 Jul 2013 09:18:16 GMT

Hi vishwa,

I already gone through that like im little bit confused

give me some what easy ways to learn this concept

Thanks & Regards

Niranjan

Fri, 12 Jul 2013 09:33:56 GMT

Hi..

If the same product table would be linked to the fact table, but now using a generic key, the solution would instead look like below :

Above the tables %ProductID is the duplicate field of ProductID,where u can map it for one to one.

regards-bika

NavinReddy — Fri, 12 Jul 2013 11:09:45 GMT

Hi,

Thanks alot for sharing your ideas

don't mind will you please explain me breaf why should we require that %ProductID

Actually i want to know about that

Thanks,

Niranjan

Fri, 12 Jul 2013 11:31:46 GMT

Let u have three table Like A,B,C

One field name is "ProductID"

If this field name is exist in all three table ,then table will link like one to many..

Best practice suggest try to link table as one to one mapping.

so i am using generic key..in this case it will take less time to load application.

NavinReddy — Sat, 13 Jul 2013 01:41:46 GMT

Hi,

Thanks alot now i am aware of Generic key concept

What is Mixed Granularity where should we impliment this

Thanks,

Niranjan