Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-11-29 05:20 AM

What's the best way to resolve this synthetic key problem

Hi all,

Very straight forward question. I have two tables with three common fields. What is the best way to resolve the synthetic key that would be formed

1. I could rename the fields in one of the tables or

2. I could create a composite key of the fields in both tables so that they associate on this instead.

Which is the best way and why?

Many thanks

190 Views
0 Likes
0 Replies