Difference between SK and ID

[debsahoo]

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.

[Anil_Babu_Samineni]

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

[sushil353]

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

[debsahoo]

How to check with DB team.

[debsahoo]

Can composite key act like surrogate key.?

[Anil_Babu_Samineni]

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.

[its_anandrjs]

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.