topic Re: Difference between SK and ID in QlikView

Difference between SK and ID

debsahoo — Wed, 25 Nov 2020 16:16:04 GMT

If a fact table contain Customer_id, Customer_sk, Product_id, Product_Sk . I know all ID is primary_key of respective dimension table. But what is SK . Is SK stands for surrogate_key or Any other key. If what then why we are using?

Please tell me.

Thanks in advance.

Re: Difference between SK and ID

Anil_Babu_Samineni — Tue, 19 Dec 2017 03:03:36 GMT

SK - In qlik, We can call it as Synthetic Key ..In a DB it called "Unique Identifier" ..

So, To understand better please check with DB team. They will help you for sure

Re: Difference between SK and ID

sushil353 — Tue, 19 Dec 2017 03:24:48 GMT

Hi Deb,

SK must be surrogate key in your case, Surrogate key is a unique identification key for dimension tables. Surrogate key is always single numeric key to improve the performance of join we use surrogate key to join dimension to the fact table as they are numeric keys.

Hope this help.

~Sushil

Re: Difference between SK and ID

debsahoo — Tue, 19 Dec 2017 06:30:29 GMT

How to check with DB team.

Re: Difference between SK and ID

debsahoo — Tue, 19 Dec 2017 06:33:10 GMT

Can composite key act like surrogate key.?

Re: Difference between SK and ID

Anil_Babu_Samineni — Tue, 19 Dec 2017 06:34:31 GMT

You need to contact Database team who sitting in your live project surrounding. So, Once you contact them they will help you exactly what does these field names are and they will guide you to understand little in detail of your part of need.

Re: Difference between SK and ID

its_anandrjs — Tue, 19 Dec 2017 06:40:43 GMT

I believe SK means Super Key Or Surrogate Key which contains Numeric value and which is easy to load or identify on the data model.