I am trying to implement SCD Type 2 with Synapse SQL POOL using MERGE option as similar to above and getting the same error. Can some one share an example of how to implement the SCD Type 2 in the Synapse SQL Pool. Scenario: Source Table: id name country 1 abc India 2 bcd US ...
您可以在hadoopsql查询引擎(hive、impala、drill等)中创建一个视图,使用窗口函数检索当前状态/最新值。...