Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Which scenarios link table is good?

Explain With practical examples any body sir.

5 Replies
Siva_Sankar
Master II
Master II

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

Anonymous
Not applicable
Author

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/

fkeuroglian
Partner - Master
Partner - Master

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."

Not applicable
Author

It's really thank you Sir.

Not applicable
Author

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 .