Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is Synthetic keys and circular reference? and diffrences
Check:
Synthetic Keys:
What is synthetic keys? How it can be avoided?
Should We Stop Worrying and Love the Synthetic Key?
Circular Reference:
http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references
Hope this was helpful.
Thanks,
Singh
hi madhu,
as you know, qlikvew makes associations between tables if a field is found to be common. synthetic keys are result of associations made by qlikview between tables when more than one field is found to be common. for example,
table A has x1,x2,x3 fields while table B has y1,x1,x2 fields. if you load these tables into the data model they'll form synthetic keys as two fields(x1,x2) are common between the two tables.
circular reference is what we call a scenario when three more tables are associated with each in a circular loop. like table a is linked to table b, table b to table c and table c to table a.
the difference between synthetic keys and circular reference is that synthetic keys occur when only when two or more fields are found common between tables while circular reference is normal association between tables but in a loop.
cheers,
kunal bhattacharya
synthetic key: when u have more than one field common between 2 tables then syn key will come
ways to remove: commenting the field, rename the field , using qualifier and unqualifier statements,
circular reference : among 2 or more fact tables having multiple common dimension then circular reference ll come.
it looks like dotted lines format in table viewer.
ways to remove: commenting the field, rename the field , using qualifier and unqualifier statements,
if u not remove these then it will affect on performance , slow down calculations
if u r ok with answer pls make it correct answer