what is Synthetic keys and circular reference? and diffrences

[#1]

what is Synthetic keys and circular reference? and diffrences

[#2]

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

[#3]

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

[#4]

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

[#5]

if u r ok with answer pls make it correct answer