Section : 4 UMY : Design and Implement Data Storage

64 : Building a Fact Table : 

We have connected to SQL Database and Azure Synapse Datawarehouse using the SSMS

We are going to build a fact table based on the "SalesOrderDetail" Table & "SalesOrderHeader" Table. 

once thing we can do is create a View based on the joint of both of these tables within my SQL database itself and then I can create a new table within my SQL database and copy that information using the pipeline tool in Azure synapse on to my SQL Datawarehouse 

If you don't want to impact your Auze SQL database as it is a production based database what you can do is use the pipeline tool to copy the data that you want to Azure synapse we are going to look into that approach when we come to Azure Data Factory .