Why Surrogate Keys are used in Data Warehouse

[kunalkumar-hlgv]

This is the best video on internet which talks about surrogate key

[bbrocks]

Please share a video on how to create a dw in step by step approach

[crazycom]

I had a question in interview on this
He asked me that the fact table has a composite PK which itself is unique and strong then why we need a SK again to uniquely identify a record...it created a lot of confusion to me and I was not able to answer it that time.

[anugyajain]

Thanku so much sir.... Very gud explaination

[grim_rreaperr]

at 5:00 shouldn't it be append instead of merge?

[hayatabadcomputeracademy]

Thanks for sharing the helpful much information in a short time.

[SharoonGill]

what to do if the store_table (dimension table) is a slowly changing dimension for which we can create a surrogate key, but for sales_table (fact table) the surrogate key is not provided to identify stores (as these keys have no meaning in the real world, imagine an external data provider giving us sales data based on store IDs). How can we use this concept then?

[Buzzingfact]

where are you man...make more videos on dwh... these are great

[jagadeeshp]

Your explanation is good, but too much speed when you speak.

[CODwontons]

Thank you for being quick and getting to the point! Some other people's videos are too slow!!

[srikantganapati]

Speak slowly to understand better. No doubt your videos are awesome.

[ramprasathselvamani]

Very straight forward explanation. Thanks a lot.

[adamk]

If a previously inserted store ID changes location, you would want to have a process that ingests the file and UPDATES the already existing store ID. This model doesn't make sense because you now have two store IDs of S1001. Are they two different locations? Did one store close?

[tripleful]

so basically it is numbering 1, 2, 3, 4 for each record. OMG what a complex concept!!

[sivakumaranbazhagan]

So what happens to the original primary key would it still exist on dimension table and if it does, what is going to be its significance now that surrogate key is also present?

[isadoralmeida]

Can I just say that the natual key in a dimension table from a DW correspond to the PK column to that same table from the database? And the SK column is the PK of the dimension table, so i will only exists on the DW. Is my thought correct?

[faisalalshawkani]

good explanations but can you please bring someone else who does not have an accent. I barely could understand you. I could not understand you at all brother.