Thursday, December 27, 2012

Exercise to implement Filter, Rank and Expression Transformation

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

1 comment:

  1. Thank you so much for providing information and diving deeper into higher aspects of tools such as Informatica and REST API.

    Informatica Read Rest API

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...