CREATE VIEW 300_fin_sat_prestamo2 AS
SELECT
  300_FIN_HUB_PRESTAMO_HKEY,
  LOAD_DATETIME,
  COALESCE(
    LEAD(
        DATE_ADD(LOAD_DATETIME, INTERVAL -1 MICROSECOND)
	  )
      OVER (
        PARTITION BY 300_FIN_HUB_PRESTAMO_HKEY -- ADD MULTI ACTIVE ATTRIBUTES
        ORDER BY LOAD_DATETIME
      )
    , CAST('2999-12-31 23:59:59.999999' AS datetime(6))
  ) LOAD_END_DATETIME,
  -- YOU CAN CALCULATE FIRST_RECORD_INDICATOR
  -- IF USE ASC INSTAEAD OF DESC
  CASE
    WHEN
      (RANK()
      OVER (
        PARTITION BY 300_FIN_HUB_PRESTAMO_HKEY -- ADD MULTI ACTIVE ATTRIBUTES
        ORDER BY LOAD_DATETIME DESC)
      ) = 1
	  THEN 'Y'
	  ELSE 'N'
	  END CURRENT_RECORD_INDICATOR,
  RECORD_SOURCE,
  HASH_DIFF,
  CDC_OPERATION,
  fecha_desembolso,
  fecha_vencimiento,
  monto,
  plazo
FROM 300_fin_sat_prestamo