salary table

INSERT INTO salary_table (day_key, salary)
SELECT
  day_key, SUM(salary)
FROM
  EMPLOYEE_DETAIL_FACT edf
GROUP BY
  day_key;