joins ,mapping,link table?

[sbkumar]

At what context we use these joins,mapping and link table?i am bit confusing when to use ,why to use ?

[jonathandienst]

If you are asking these sort of questions, then I suggest that you buy a Qlikview/QlikSense book or look up the online training on the Qlik Site. Or you can read these

Get started with developing qlik datamodels

Advanced topics for creating a qlik datamodel

[imrasyed · Accepted solution]

Breifly speaking;

These are the techniques to design our DataModel for better performance,

Like removing circular loops and Synthetic Keys.

Some Qlikview Joins,Keep,Concatenation and Applymap best documents

Joins:

Join is used to merge tables based on the common key.

In qlikview the two tables are merged upon joining.

Mapping: Table A     Table B

                  F1              F1

                  F2             F3

                                   Fn

We can move field F2 to Table B using Mapping concept and the Table A will dropped automatically.

Mapping is similar to join but better than Join as per the performance.

.

Link Table:

If you have more than one common field between  tables than we can create the Link Table to remove Synthetic key formed.