Configured the Hermes Transfer Refresh ETL script and added a BRAND filter. Also added a BRAND filter in the DELETE statement. Created a ktr which will trigger the shell script and acquire the parameter values.