Link Table

Wed, 14 Mar 2012 08:40:51 GMT

What do we mean by Link Table ???? please explain from the basics????????

Link Table

kamalqlik — Wed, 14 Mar 2012 09:34:41 GMT

Hi Manish,

Link tables are generally used for linking the two table or the fact tables.

Let us go with an example..

As we know that when we are designing the datamodel synthetic keys and circular loop are common.

For fixing this problems we use the link table concept.

You can also use concatenation ,but it always not give the appropiate result.

Concatenation works well enough when we have all the fields same.

With the use of link tables, it’s possible to keep the facttables separated from each other. The advantage of this solution for choosing this method is to keep the datamodel a logical one.

Hope this help you.

regards

Kamal

Re: Link Table

Anonymous — Fri, 05 Oct 2012 11:30:07 GMT

Hi Kamal,

If you have any example file, please upload for better and ease of implementation.

Thanks in advance.

Best Regards,

Skumar

topic Re: Link Table in QlikView

Link Table

Link Table

Re: Link Table