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

Channel Avatar
Comment
X
Share
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.DEPTNODEPT.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
https://youtu.be/JTpcvNWT4jw

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Keywords: powercenter, informatica, iics, cloud, orcale, unix, sql, data, intration, migration, workflow, mapping, mapping task, taskflow, learning, tutorial, beginner, sql transformation, query mode

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *