What is Generic keys

[NavinReddy]

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]

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

[#3]

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]

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

[#5]

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]

Hi,

Thanks alot now i am aware of Generic key concept

What is Mixed Granularity where should we impliment this

Thanks,

Niranjan