Forum Discussion
Advocate IIIndentity and surrogate key
Below link describes the alternatives:
Fabric warehouse is an MPP framework and OLAP (more for analytics purpose)
In case if you want a replicae of SQL server, you can leverage fabric databases rather than fabric warehouse for your use case
Hi Si_7777 you can also use this approach in Fabric Warehouses, which is what I currently use
Generate unique identifiers in a warehouse table - Microsoft Fabric | Microsoft Learn
As NandanHegde said, if you need all the functionality of an RDBMS then Fabric SQL Databases have you covered.
Super UserBelow link describes the alternatives:
Fabric warehouse is an MPP framework and OLAP (more for analytics purpose)
In case if you want a replicae of SQL server, you can leverage fabric databases rather than fabric warehouse for your use case
Advocate IIThank you for replying. I wouldnt say we need to replicate SQL server as such. I have been tasked with moving our current solution to the cloud and I asssumed Fabric Data Warehousing was the way forward. We have dimensions and facts currently using SSIS for ETL.