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

Описание к видео 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 Dynamic Queries f...  

Комментарии

Информация по комментариям в разработке

Похожие видео