Complete this when you finish reading Filter, Rank and Expression transformation
Using Scott schema
Calculate the Tax(14% of SAL) for top 3 employees based on salary who belongs to Sales department and Sales department ID is 30.
Create Target_Emp which contains the following columns EmpNO, Ename, Job, Sal, Tax and Deptno
EMP -----> SQ_EMP ---------> DEPTNO=30--------> Tax= SAL*0.14------> Target_Emp
EMP ----> SQ_EMP ------> DEPTNO=30-----> Top3(SAL)----> Tax= SAL*0.14-----> Target_Emp
Filter T/F Rank T/F Expression T/F
PROCEDURE
Will update shortly
Using Scott schema
Calculate the Tax(14% of SAL) for top 3 employees based on salary who belongs to Sales department and Sales department ID is 30.
Create Target_Emp which contains the following columns EmpNO, Ename, Job, Sal, Tax and Deptno
EMP -----> SQ_EMP ---------> DEPTNO=30--------> Tax= SAL*0.14------> Target_Emp
EMP ----> SQ_EMP ------> DEPTNO=30-----> Top3(SAL)----> Tax= SAL*0.14-----> Target_Emp
Filter T/F Rank T/F Expression T/F
PROCEDURE
Will update shortly
Thank you so much for providing information and diving deeper into higher aspects of tools such as Informatica and REST API.
ReplyDeleteInformatica Read Rest API