IICS | Query Mode in SQL Transformation in Informatica Cloud | Get Employee detail by Passing DeptNo 

Hi Frieds below are file data and sql used .
Source file :
dept_id
10
30
50
SQL :
SELECT
EMP_BKUP.EMPNO AS EMP_ID,
EMP_BKUP.ENAME AS EMP_NAME,
EMP_BKUP.SAL1 as EMP_SAL,
EMP_BKUP.DEPTNO AS DEPTNO
FROM SRC.EMP_BKUP INNER JOIN SRC.DEPT ON EMP_BKUP.DEPTNO=DEPT.DEPT_ID
AND DEPT.DEPT_ID= ?DEPT_ID?
the emp bakup and dept table DDL and insert statement are available in my previous video description , please take it from there , the video is
• IICS | Run Multiple Dy...