IICS | Run Multiple Dynamic Queries from File as Input using SQL Transformation in Informatica Cloud

Flat File used :
query
DROP TABLE EMP_SAL_BY_DEPT;
DROP TABLE EMP_SAL_BY_DEPT_TABL2;
CREATE TABLE EMP_SAL_BY_DEPT AS SELECT ROUND(AVG(EMP_BKUP.SAL1)) as AVG_SAL,EMP_BKUP.DEPTNO AS DEPTNO FROM SRC.EMP_BKUP INNER JOIN SRC.DEPT ON EMP_BKUP.DEPTNO=DEPT.DEPT_ID GROUP BY EMP_BKUP.DEPTNO;
CREATE TABLE EMP_SAL_BY_DEPT_TABL2 AS SELECT EMP_BKUP.SAL1 as SAL, EMP_BKUP.DEPTNO AS DEPTNO FROM SRC.EMP_BKUP INNER JOIN SRC.DEPT ON EMP_BKUP.DEPTNO=DEPT.DEPT_ID;


tables used :
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7369,'SMITH','DEVELOPER',7902,to_date('17-DEC-80','DD-MON-RR'),800,30,20,'UNITED KINGDOM',100);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7499,'ALLEN','SALESMAN',7698,to_date('20-FEB-81','DD-MON-RR'),1600,300,30,'INDIA',50);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7521,'WARD','SALESMAN',7698,to_date('22-FEB-81','DD-MON-RR'),1250,500,30,'UNITED KINGDOM',60);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7566,'JONES','MANAGER',7839,to_date('02-APR-81','DD-MON-RR'),2975,600,20,'INDIA',100);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7654,'MARTIN','SALESMAN',7698,to_date('28-SEP-81','DD-MON-RR'),1250,1400,30,'MEXICO',50);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7698,'BLAKE','MANAGER',7839,to_date('01-MAY-81','DD-MON-RR'),2850,null,30,'CANADA',60);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7782,'CLARK','MANAGER',7839,to_date('09-JUN-81','DD-MON-RR'),2450,null,10,'MEXICO',100);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7788,'SCOTT','ANALYST',7566,to_date('19-APR-87','DD-MON-RR'),3000,null,20,'INDIA',50);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7839,'KING','PRESIDENT',null,to_date('17-NOV-81','DD-MON-RR'),5000,null,10,'UNITED KINGDOM',60);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7844,'TURNER','SALESMAN',7698,to_date('08-SEP-81','DD-MON-RR'),1500,0,30,'INDIA',100);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7876,'ADAMS','CLERK',7788,to_date('23-MAY-87','DD-MON-RR'),1100,null,20,'UNITED KINGDOM',50);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7900,'JAMES','CLERK',7698,to_date('03-DEC-81','DD-MON-RR'),950,10,30,'CANADA',60);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7902,'FORD','ANALYST',7566,to_date('03-DEC-81','DD-MON-RR'),3000,null,20,'MEXICO',100);
Insert into SRC.EMP_BKUP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL1,COMM,DEPTNO,COUNTRY,SAL2) values (7934,'MILLER','CLERK',7782,to_date('23-JAN-82','DD-MON-RR'),1300,null,10,'UNITED KINGDOM',50);

DEPT :
Insert into SRC.DEPT (DEPT_ID,DEPT_NM) values (10,'SALES');
Insert into SRC.DEPT (DEPT_ID,DEPT_NM) values (20,'FINANCE');
Insert into SRC.DEPT (DEPT_ID,DEPT_NM) values (30,'HR');