RE: Can we run SQL’s on target table before and after loading the actual data?
Yes, Diyotta provides a feature to run Sqls before/after loading the data into actual target through PreSQL and PostSQL. This is given in target instance properties. When we wanted to run any queries before running actual design that sql can be given in PreSQL. In the same way if have any sql is to run after running the design that can be given in PostSQL.