What is synthetic key and how to avoid it in qlikview?
Answer Posted / Rakesh Nath Tripathi
A Synthetic Key in QlikView is a unique identifier created by the software to replace missing or non-unique natural keys. It can cause issues when joining tables or performing calculations. To avoid using synthetic keys, you should ensure that your data has unique and meaningful primary keys (natural keys) before loading it into QlikView.nnYou can also use the 'Keyed by' load statement to explicitly define the key fields.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers