SYNTHETIC KEY?

[#1]

why synthetic keys if we don't avoid what about data integrity and performance?

[Gysbert_Wassenaar]

See this blog post: Synthetic Keys

[fkeuroglian]

Read this, hope helps

http://www.learnallbi.com/qlikview-resolving-synthetic-keys/

Fernando

[Anonymous]

Hi

Wheb  two  tables share more than one common field, qlikview create synthetic key,to try and associate both tables through the combination of all of the common fields between them

example:

You can  see this blog:

Qlikview Synthetic Keys | Michael Ellerbeck

[markodonovan]

Hi Siva,

For a simple introduction see the following youtube video:

Practical QlikView Training Course 15/49 - Synthetic Tables - Part 1 - YouTube

Thanks

Mark

www.techstuffybooks.com

[SunilChauhan]

one or two synthetic are  not degrading the performace or disturbing integraty of data. if we understand it its nothing but like a composite key.

but if we have multiples synthetic keys in our model then it will definetely do impact.

i have seen that sometime its even take more time to load data

hope this helps

[ashfaq_haseeb]

Hi,

Check this too.

http://community.qlik.com/message/10279#10279

Regards

ASHFAQ