topic Re: Which scenarios link table is good? in QlikView

Which scenarios link table is good?

Sat, 19 Jul 2014 14:15:14 GMT

Explain With practical examples any body sir.

Re: Which scenarios link table is good?

Siva_Sankar — Sat, 19 Jul 2014 14:25:41 GMT

Ramesh,

It’s hard to find a general rule to determine when you should Concatenate rather than joining tables by a Link Table .

You probably check out the following blog and read the attached document.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table

Re: Which scenarios link table is good?

Anonymous — Sat, 19 Jul 2014 14:29:08 GMT

I quote from Oleg Troyansky

Concatenated Facts perform much better than data structures with Link Tables

See: www.naturalsynergies.com/q-tip-9-concatenate-or-join/

Re: Which scenarios link table is good?

fkeuroglian — Sat, 19 Jul 2014 14:51:04 GMT

Bill

Textual of the book Qlikview for developers

"Finding a Balance"

We have outlined two ways for dealing with multiple fact tables in data model, if we were to ask which of these method is better(concatenate or link table), we would need to say "IT DEPENDS".

There is no define best, and the decision about which to use will depend entirely on the specific scenario where it has to be implemented."

Re: Which scenarios link table is good?

Sat, 19 Jul 2014 15:28:06 GMT

It's really thank you Sir.

Re: Which scenarios link table is good?

Sun, 04 Jan 2015 22:31:09 GMT

Because Qlikview is excellent at compressing duplicate values, concatenate is generally my first instinct.

Link Tables, in my opinion, should only be used when concatenate simply does not make sense. For example, creating a Canonical Calendar .