Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
why synthetic keys if we don't avoid what about data integrity and performance?
See this blog post: Synthetic Keys
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:
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
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