topic what is Synthetic keys and circular reference? and diffrences in QlikView

what is Synthetic keys and circular reference? and diffrences

Wed, 29 Oct 2014 05:39:13 GMT

what is Synthetic keys and circular reference? and diffrences

Re: what is Synthetic keys and circular reference? and diffrences

Wed, 29 Oct 2014 05:55:14 GMT

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

Re: what is Synthetic keys and circular reference? and diffrences

Wed, 29 Oct 2014 06:27:26 GMT

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

Re: what is Synthetic keys and circular reference? and diffrences

Wed, 29 Oct 2014 06:37:51 GMT

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

Re: what is Synthetic keys and circular reference? and diffrences

Wed, 29 Oct 2014 09:19:07 GMT

if u r ok with answer pls make it correct answer