I am working with one database where the transformations- all joins, case statements, adding new column happens in the view. I am unable to find a definite answer on how doing this in the view compared to stored procedures and having all the data ready as needed stored in the underlying table would perform?
Is it a best practice to do such complex joins and have a whole bunch of transformation code actually residing in the views?
This view is later read by Power BI.
Database is in Azure SQL DW dedicated SQL pool.
Appreciate any links to reading or if you have an answer to that please share. Thanks.