topic Re: syn key? in QlikView

syn key?

Thu, 16 Apr 2015 03:43:50 GMT

if i am not removing synthtickey what will happen ?

pls advce

Re: syn key?

Miguel_Angel_Baeyens — Thu, 16 Apr 2015 07:21:33 GMT

Hi Satya,

If your model has been built correctly, and indeed all fields in the synthetic table are the same (key-foreign key fields) then nothing wrong will happen.

If you did not expect synthetic keys to happen, then they are likely the result of some issue while modelling, where although two fields are named alike, they don't really contain the same information (e.g: field ID in Customer table and field ID in Invoice table refer to different entities). In this case, you will see erroneous results and you should be fixing that modelling issue.

Miguel

Re: syn key?

amit_saini — Thu, 16 Apr 2015 07:31:09 GMT

Hi,

Check this:

https://community.qlik.com/message/479497#479497

Thanks,
AS

Re: syn key?

ankitaag — Thu, 16 Apr 2015 07:44:59 GMT

Also, those synthetic keys are using extra memory of your RAM, so rather than making synthetic tables concatenate the desired columns to make 1 key.

Re: syn key?

Anonymous — Thu, 16 Apr 2015 07:52:50 GMT

Hi Satya,

Go through HIC's Blog . Hope it will help you.

Synthetic Keys

Thanks

BKC

Re: syn key?

Miguel_Angel_Baeyens — Thu, 16 Apr 2015 09:08:39 GMT

Hi Ankita,

Not always, as shown in the blog below. If synthetic keys are looked for as a way to save development time, they will not use more memory or CPU that any other key.

However, if we recommend not to use synthetic keys it is not because performance, but mainly because they are produced as a result of a bad data modelling that is the issue.

Miguel