topic Re: by using mapping we can remove synthetic key are circular refernces loop in QlikView

by using mapping we can remove synthetic key are circular refernces loop

Thu, 16 Apr 2015 11:45:32 GMT

pls tell

Re: by using mapping we can remove synthetic key are circular refernces loop

buzzy996 — Thu, 16 Apr 2015 11:50:31 GMT

what do u mean mapping here? in qlikview mapping is key word we can use for the other way as well.

if u mean mapping here(by create same field name) on multiple tables,yes we can remove the above two things.

Re: by using mapping we can remove synthetic key are circular refernces loop

Gabriel — Thu, 16 Apr 2015 11:54:15 GMT

Hi,

There are 3 different topic in your question. A good clarification of your requirement is necessary to accurate answer from the community.

You have MAPPING, Syn Key and Circular reference. Which of this do you require understanding of?

Re: by using mapping we can remove synthetic key are circular refernces loop

morganaaron — Thu, 16 Apr 2015 13:09:10 GMT

If you're asking "can we avoid circular references or synthetic keys by using mapping?" the answer is yes. By using mapping tables, you can avoid the need to load the same fields into multiple tables, which would cause a synthetic key between the two tables in which the multiple fields reside. Similarly, having the same field in multiple tables can cause a circular reference - so again, by mapping, you reduce the number of times a field needs to appear and therefore avoid unnecessary or problematic joins.