topic Re: Synthetic Keys in QlikView

Synthetic Keys

priyarane — Sun, 08 Mar 2015 07:14:49 GMT

Hi Experts,

I have a doubt on synthetic keys, that is - what kind of scenario we can keep Synthetic keys in our Data model.

Thank you.

Re: Synthetic Keys

maxgro — Sun, 08 Mar 2015 07:48:52 GMT

did you read this?

Synthetic Keys

Re: Synthetic Keys

fkeuroglian — Sun, 08 Mar 2015 13:17:34 GMT

Hi Priya, see this

hope helps

Should We Stop Worrying and Love the Synthetic Key?

QlikView – Resolving Synthetic keys | Learn QlikView

Synthetic Keys

Re: Synthetic Keys

petter — Sun, 08 Mar 2015 15:40:50 GMT

If you use an INTERVAL MATCH it will create a synthetic key which you will have to keep.

If you get synthetic keys due to source tables you should definitely resolve them into bridge tables/link tables so you verify the need for them for yourself and others. It gives you the opportunity to put sensible field names on the generated synthetic fields also - which is important.