SCD Type 2 in Microsoft Fabric and Power BI

[@bradj229]

Great video! Thanks for taking the time to go step by step 👍🏻

[@RADACAD]

Glad it was helpful!

[@sanishthomas2858]

Does the merge statement not support in fabrics? For the scd2 u could have used that right?

[@VictorHugo-bd3bf]

Thank you very much, Reza. This is very helpful.

[@RADACAD]

You're very welcome

[@cheaptube4918]

Very helpful! Thank you!

[@RADACAD]

You're welcome!

[@joaorataoo]

Thank you, Reza. Very helpful. You mentioned that you were going to put some links to other videos, but I don't see them.

[@RADACAD]

All the links are from the blog article that is in the description

[@SandroQuinta]

Can I apply this your SCD2 method when working with incremental loading?

[@RADACAD]

Yes you can

[@mv1597]

Thanks for this tutorial! I can't see the link to the blog in the description, could you please put it it in there as I'd like to have a go using the code.

[@mv1597]

Just found the blog post - Just curious about when you are creating the customer dimension why the PK is 'NON CLUSTERED' and 'NOT ENFORCED' Also do you store your table creation scripts inside 'My queries' or inside the 'Stored Procedures' section of the schema that it is in Thanks!

[@RADACAD]

glad you found it helpful. there are many configurations for the primary key and other columns in the tables, non clustered and not enforced are just a few. explanation of that will be requiring its own video series (which I hope at some point I have time to record) in terms of where to store these scripts: My queries is a good place to save your "work in progress" queries, so that you can easily get back to them and try them, but recommended to use meaningful names rather than new query 1, etc. If you finalized the script though, then they would be better to become stored procedures, functions and views for more frequent use later.

[@mv1597]

@@RADACAD Thank you so much! I will be referring back to this video a lot as I'm trying to build a Kimball Dimensional model in Fabric with type 2 SCDs If I can also ask, which part of the script is used to generate the surrogate PKs and dates for the gold layer? I've been able to get the data across from silver lakehouse to the gold warehouse with a sql query, but there is an error when I try to add the data from the lakehouse into the warehouse table because the lakehouse data doesn't contain values for dates and surrogate keys so there is a mismatch in the number of columns. Looking forward to those future videos, it would be great to see one going into detail on the stored procedures!

[@MohamedMontaser91]

there are no links in the description

[@RADACAD]

thanks for point out. fixed now

[@MohamedMontaser91]

why does it take 7 seconds to query an empty table?