Knowledgebase: Tips and Tricks
Key/Link Table in QlikView
Posted by Tier1 Support on 04 May 2016 04:52 PM

This Article explain how to connected to a central key table.

key/link table is frequently required in QlikView to resolve Synthetic Key or Circular Join issues.  It can also help to tidy  up a schema that has tables all over the place.  The goal is to create a star (and sometimes snowflake) schema with dimension tables connected to a central key table.  Unlike in classical data warehousing, the central table doesn't often have the measures - they generally stay in the dimension tables.



Attachments 
 
 Link tables.docx (81.13 KB)
 Link_Table.qvw (167.50 KB)
(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).