Checked the Tendam Sales Refresh ETL on what causes the 0 values of DISCOUNT column in sale_facts. Identified this is caused by CSDSTS assigned as discount in select step instead of CSEXDS. Corrected this and performed refresh for the dates with missing discount value.