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

[#1]

pls tell

[buzzy996]

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.

[Gabriel]

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?

[morganaaron]

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.