LOAD_END_DATE Satellite View

CREATE VIEW [VW_SATELLITE] AS
SELECT s.[HASHKEY]
      ,s.[LOAD_DATETIME]
      ,LEAD(s.[LOAD_DATETIME], 1, '9999-12-31') OVER (PARTITION BY s.[HASHKEY] ORDER BY s.[LOAD_DATETIME]) AS LOAD_END_DATETIME
      ,s.[RECORD_SOURCE]
      ,s.[HASH_FULL_RECORD]
      ,s.[ATTRIBUTE1]
      ,s.[ATTRIBUTE2]
  FROM SATELLITE s